On Sat, 2005-05-07 at 18:24 +0200, Wolfgang Rohdewald wrote: > Am I correct in assuming that I should put tables with indices > relevant for the query in front? >
No. You should order tables in a join so that selection criteria for each table depends only on tables to the left. In your example, the row chosen from album depends on which row is chosen from track. So track should be to the left of album. See http://www.sqlite.org/php2004/page-056.html and the 3 pages that follow. Pay particular attention to the final bullet on http://www.sqlite.org/php2004/page-058.html -- D. Richard Hipp <[EMAIL PROTECTED]>
