Can you you isNULL with mySQL? -----Original Message----- From: Paul Johnston [mailto:[EMAIL PROTECTED]] Sent: 29 January 2003 15:52 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SQL: Completely half asleep
> SELECT a.fld1, a.fld2, b.fl4 > FROM tbl1 a > LEFT INNER JOIN tlb2 b > ON a.fld1 = b.fld1 > ORDER BY a.fld1 > Doesn't work.. Problem is that I have criteria to match on both sides. Remember I need to test what a.fld3 is and b.fld4 is It's just a bit strange, because ths query is easy to do: SELECT a.fld1, a.fld2, b.fld4 FROM tbl1 a, tbl2 b WHERE a.fld1 = b.fld1 AND a.fld1 = 84 AND b.fld4 = 39 But this gives: Fld1 fld2 145 val1 146 val2 148 val4 And I need the other two rows in there with a null value... Paul -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
