On Wed, October 18, 2006 13:21, spacemarc said: > ok, instead I use > (SELECT * FROM tab1 WHERE mydate between 'the-date1' and 'the-date2' ) > UNION > (SELECT * FROM tab2 WHERE mydate between 'the-date1' and 'the-date2' ) > etc.... > > But if I wanted to use a join I can make it however or not? > > > > -- > http://www.spacemarc.it > A JOIN implies that the tables are related, that is, a column (or columns) in table a has the same value as a column (or columns) in table b. Thats what they mean when they call it a RELATIONAL database. If the tables don't have such a relationship you are asking for the UNION of the separate information from table a, where it meets its WHERE conditions, and the information from table b where it meets its WHERE conditions. The fact that both where conditions are the same doesn't matter. Hope this helps.
------- William R. Mussatto, Senior Systems Engineer http://www.csz.com Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]