SELECT ... FROM TABLE1 a, TABLE2 b, LEFT JOIN TABLE3 c ON a.field1 = c.field1 AND c.field3 != 'string' WHERE a.field1 = b.field1;
If field3 in table c can be NULL and you still want to have this record included you have to modify it to ... AND ifnull(c.field3,'string') = 'string' ... Please know that there is a differences of a column being NULL or if no record exists for specific join condition! Cheers /rudy -----Original Message----- From: Krasimir_Slaveykov [mailto:[EMAIL PROTECTED] Sent: donderdag 10 juli 2003 12:37 To: [EMAIL PROTECTED] Subject: constructing SQL problem Hello , I have a problem with constructing correct SQL. I have tables: TABLE1 wich have FIELD1 and FIELD2 TABLE2 wich have FIELD1 and FIELD2 TABLE3 wich have FIELD1, FIELD2 and FIELD3 I have this SQL: select a.field1, a.field2, b.field2, c.field2 from TABLE1 as a, TABLE2 as b, TABLE3 as c where a.field1=b.field1 and a.field1=c.field1 and c.field3<>'string' My problem is that when C.FIELD3 is null i.e. in TABLE3 no record, these records are excluded from results. I needed them nevermind they have record in TABLE3 or not. Anyone help? -- Best regards, Krasimir_Slaveykov mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] -- 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]