| 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 tables | spacemarc | 18 Oct |
| • Re: Simple JOIN on three tables | William R. Mussatto | 18 Oct |
| • Re: Simple JOIN on three tables | Rolando Edwards | 18 Oct |
| • Re: Simple JOIN on three tables | spacemarc | 18 Oct |
| • Re: Simple JOIN on three tables | Peter Brawley | 18 Oct |
| • Re: Simple JOIN on three tables | spacemarc | 18 Oct |
| • Re: Simple JOIN on three tables | William R. Mussatto | 18 Oct |
| • Re: Simple JOIN on three tables | spacemarc | 18 Oct |
| • Re: Simple JOIN on three tables | Peter Brawley | 18 Oct |
| • Re: Simple JOIN on three tables | William R. Mussatto | 18 Oct |
| • Re: Simple JOIN on three tables | Martijn Tonies | 19 Oct |
