Hi, See 5.0 JOIN syntax at http://dev.mysql.com/doc/refman/5.0/fr/join.html
Example: SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id Regards, Geoffroy -----Message d'origine----- De : Gmail User [mailto:[EMAIL PROTECTED] Envoyé : samedi 2 juin 2007 22:55 À : mysql@lists.mysql.com Objet : Re: mysql old 4.* query fails on 5.* > Anyone know whats wrong here? Try as ... >From (Klienter AS K, Tid As Td, Personal AS P) JOIN Uppdrag AS U ON K.Klient_ID = U.Klient_ID ... or ... >From Tid As Td, Personal AS P, Klienter AS K JOIN Uppdrag AS U ON K.Klient_ID = U.Klient_ID ... This is the problem I had in one of my queries. The join is on the last table on the left side. Either use parentheses or put K table last. HTH, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
