find least of date among many tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

dear friends.
i have 7 tables and all the tables contains date field
now how to find out the least of date among all the tables and
how to find out the lastvalue (very recent value)of date among all the
fielkds
and finally i should have only such 2 values only in the query.
 
You first need to find the first date in each table. Do that by using Min()
in an aggregate query, or by sorting and using the TOP predicate. Next
either use a Union query, or output the results into a temporary table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default Value as last date in a table? 5
Finding the max among several columns 13
Get Rid of Relationship Among "ID" fields 3
linking tables and relationships 3
Suggest a solution - Table design 8
Find nearest value 4
Date Dispaly 3
Relationships among 3 tables 4

Back
Top