tbl1 T2
WHERE T1.a=T2.a AND T1.c='R' AND T2.c='T';
My real query is much worse than this.
Any suggestions?
--Bill
>
>
> -Original Message-
> From: Bill Adams [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 31, 2001 12:21 PM
> To: Mysql List
>
Try going with simply:
SELECT T1.*, T2.* FROM tbl1 T1, tbl2 T2
WHERET1.a=1AND T1.b=2 AND T2.a=2 AND T2.b=T1.b;
-Original Message-
From: Bill Adams [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001 12:21 PM
To: Mysql List
Subject: Left join w/o on or using join_condition
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
tab