Re: Compare 2 fields in different tables using IF
Is this what you mean?
select ...
from tour_anal a
join tour_hdr h on ...
join tour_det d on ...
where h.diettour_type = if( h.paxno=d.paxno,'TourHdr', 'TourSet') ...
Subject
Written By
Posted
February 16, 2018 06:31AM
February 16, 2018 09:07AM
February 16, 2018 09:19AM
February 16, 2018 09:21AM
Re: Compare 2 fields in different tables using IF
February 16, 2018 09:51AM
February 16, 2018 11:58AM
February 19, 2018 03:38AM
February 19, 2018 05:17AM
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.