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 JoinGraham Anderson24 May
  • Re: Noob: Converting to Inner JoinChris Sansom24 May
    • Re: Noob: Converting to Inner JoinGraham Anderson24 May
    • Re: Noob: Converting to Inner JoinPeter Brawley24 May
      • Re: Noob: Converting to Inner JoinChris Sansom24 May
        • Re: Noob: Converting to Inner JoinPeter Brawley24 May