Two tables, two selects: SELECT fld1, fld2 FROM tbl1 WHERE fld3 = 39
SELECT fld1, fld4 FROM tbl2 WHERE fld4 = 84 This gives: Fld1 fld2 145 val1 146 val2 147 val3 148 val4 149 val5 And Fld1 fld4 145 vala 146 valb 148 valc What I want is this table: Fld1 Fld2 Fld4 145 val1 vala 146 val2 valb 147 val3 NULL 148 val4 valc 149 val5 NULL What's the SQL? And I just can't remember anything today... Too many regexes in the last two days! Paul ------------------------------------------- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 -- ** 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]
