Done. On Thu, 14 Aug 2003, Jack Dare wrote:
> Doh! You are so right. Thanks for the help. Got so used to not needing the > INNER word that I forgot all about it. > > -----Original Message----- > From: Kevin Fries [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 14, 2003 1:27 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Join syntax diff 3.23 to 4.x? > > > 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] > > > > > > > > -- =============================================================== Vladimir Dubnikov (Unix System Group) Computation center, Mount Scopus, Hebrew University of Jerusalem Tel: 02-5883070 E-mail: [EMAIL PROTECTED] =============================================================== -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
