My mind is not working with me this morning... According to the manual about join syntax: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOIN
One should be able to do a LEFT JOIN without a join_condition, eg. an "ON" or a "USING": > table_reference LEFT [OUTER] JOIN table_reference However a query like: SELECT T1.*, T2.* FROM tbl1 T1 LEFT JOIN tbl2 T2 WHERE T1.a=1AND T1.b=2AND T2.a=2 AND T2.b=T1.b; Gives me a "ERROR 1064: You have an error in your SQL syntax near 'WHERE..." What am I doing wrong? You used to be able to do that. I know the conditional can be moved into a ON( ... ) but I do not want to do that for compatibility with other DBs. MySQL 3.23.41 --Bill --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php