SELECT a.fld1, a.fld2, b.fl4
FROM tbl1 a
LEFT INNER JOIN tlb2 b
ON a.fld1 = b.fld1
ORDER BY a.fld1
?
> -----Original Message-----
> From: Paul Johnston [mailto:[EMAIL PROTECTED]]
> Sent: 29 January 2003 15:26
> To: [EMAIL PROTECTED]
> Subject: [ cf-dev ] SQL: Completely half asleep
>
>
> 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]
>
--
** 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]
