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]