Re: Simple JOIN on three tables

[spacemarc]

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