On Wed, October 18, 2006 12:46, spacemarc said:
> I have 3 tables with the same fields.
> I would want to find the data that they are comprised in the time
> SELECT a.*, b.*, c.*
> FROM tab1 a, tab2 b, tab3 c
> WHERE a.date between 'YYYY-MM-DD' and 'YYYY-MM-DD'
> OR b.date between 'YYYY-MM-DD' and 'YYYY-MM-DD'
> OR c.date between 'YYYY-MM-DD' and 'YYYY-MM-DD'
> ORDER BY a.date DESC
> But this query returns all the fields duplicated.
> Where it is mistaken?
Well that's what you asked it to do, if you look closely at your query.
How are table a, b, and c related to each other?
Do you want all the information from each of the tables (which are NOT
related to each other) between the specified dates? If that is the case
you are looking at a UNION rather than a strait JOIN.
William R. Mussatto, Senior Systems Engineer
Ph. 909-920-9154 ext. 27