A newbie question on SQL
From: Terry Sutton <suttont_at_Dayton.fsp.com>
Date: Fri, 17 Feb 1995 18:41:06 GMT
Message-ID: <D45qKI.9Jv_at_Dayton.fsp.com>
Date: Fri, 17 Feb 1995 18:41:06 GMT
Message-ID: <D45qKI.9Jv_at_Dayton.fsp.com>
hung Ley wrote :
> a buncha stuff
Someone has already pointed out that you had the outer join symbol on the wrong side of the equation. I think you will also have a problem with your last 2 conditions-- you say you want to output when there are null values when there are no matching records in TableB, yet you say that b.latest_flag = 'Y'. If b.latest.flag must equal 'Y', then you will get no output when there is no matching record (i.e., b.latest_flag = null). Received on Fri Feb 17 1995 - 19:41:06 CET