Try changing "JOIN list_states " to "INNER JOIN list_states "
Looks like the earlier version didn't like your (synonymous) wording. > -----Original Message----- > From: Jack Dare [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 14, 2003 8:35 AM > To: [EMAIL PROTECTED] > Subject: Join syntax diff 3.23 to 4.x? > > > Is there something about 3.23 that makes this illegal? It is > fine on 4.012. > > SELECT [lots of columns] > FROM new_people p LEFT JOIN new_address ad ON p.address_id = > ad.id JOIN list_states ls ON ad.state = ls.id WHERE p.company_id = 1 > > Will some minor rewording help it run on both versions OK? > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]