Using WHERE to join tables instead of explicitly using JOIN

What's happening at the Club. You can post your suggestions and ideas here, along with reports of any problems using the site.

Moderators: IMOC Moderators, IMOC Committee Members

Post Reply
Speedy
Posts: 8413
Joined: Thu Dec 16, 2004 10:38 am
Location: Leamington Spa
Contact:

Using WHERE to join tables instead of explicitly using JOIN

Post by Speedy »

MySQL can sometimes optimize it better than using explicit join statements? Just a thought, might not be appropriate :)

(Just from seeing the oodles of Debug :D)
poyntesm

Re: Using WHERE to join tables instead of explicitly using J

Post by poyntesm »

Speedy wrote:MySQL can sometimes optimize it better than using explicit join statements? Just a thought, might not be appropriate :)

(Just from seeing the oodles of Debug :D)


You try make one small change on the fly and get caught...but yeah in general we use WHERE not JOIN...
Post Reply

Return to “Club News and Announcements”