List:General Discussion« Previous MessageNext Message »
From:spacemarc Date:October 18 2006 8:45pm
Subject:Re: Simple JOIN on three tables
View as plain text  
2006/10/18, William R. Mussatto <mussatto@stripped>:
> Then it is really a UNION. I hope you have the date field as an index
> otherwise you are looking at a table scan which is always slow.

Ok, if I have the field ID that have the same value in three tables
but I want to select however the data based on the date (YYYY-MM-DD)

-- 
http://www.spacemarc.it
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