Re: subselect fails
> (1) Though workunitid exists in both workunit (w.) and billing (b.) tables, the sql result set shows it only once.
If there's one b row matching one w row, that's what you'd expect.
(2) If there is no corresponding workunitid in b., the sql result shows workunitid as NULL
So is that.
Consider reading about inner joins and left joins.
Subject
Written By
Posted
Re: subselect fails
June 22, 2018 03:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.