| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Graham Anderson | Date: | May 24 2006 6:17am |
| Subject: | Noob: Converting to Inner Join | ||
| View as plain text | |||
Are there any advantages to converting this 'working' query below to use INNER JOIN ? If so, what would the correct syntax be ? Many thanks SELECT category.name, page.name, content.title, content.body FROM category, page, content WHERE content.page_id = page.id AND page.category_id = category.id AND category.id =1 ORDER BY content.order_id ASC LIMIT 0 , 30
| Thread | ||
|---|---|---|
| • Noob: Converting to Inner Join | Graham Anderson | 24 May |
| • Re: Noob: Converting to Inner Join | Chris Sansom | 24 May |
| • Re: Noob: Converting to Inner Join | Graham Anderson | 24 May |
| • Re: Noob: Converting to Inner Join | Peter Brawley | 24 May |
| • Re: Noob: Converting to Inner Join | Chris Sansom | 24 May |
| • Re: Noob: Converting to Inner Join | Peter Brawley | 24 May |
