List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:October 18 2006 8:25pm
Subject:Re: Simple JOIN on three tables
View as plain text  
 >But if I wanted to use a join I can make it however or not?

You can join on any row(s) you like. What are you trying to acccomplish?

PB

spacemarc wrote:
> 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?
>
>
>


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.5/483 - Release Date: 10/18/2006

Thread
Simple JOIN on three tablesspacemarc18 Oct
  • Re: Simple JOIN on three tablesWilliam R. Mussatto18 Oct
  • Re: Simple JOIN on three tablesRolando Edwards18 Oct
    • Re: Simple JOIN on three tablesspacemarc18 Oct
      • Re: Simple JOIN on three tablesPeter Brawley18 Oct
        • Re: Simple JOIN on three tablesspacemarc18 Oct
          • Re: Simple JOIN on three tablesWilliam R. Mussatto18 Oct
            • Re: Simple JOIN on three tablesspacemarc18 Oct
          • Re: Simple JOIN on three tablesPeter Brawley18 Oct
      • Re: Simple JOIN on three tablesWilliam R. Mussatto18 Oct
  • Re: Simple JOIN on three tablesMartijn Tonies19 Oct