how do i select the join key for the full outbound join?

Use

coalesce(p.business_id, s.business_id) as business_id

Or

nvl(p.business_id, s.business_id) as business_id

Or CASE statements like in this answer: https://stackoverflow.com/a/37744071/2700344

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top