-1

I want to join table1 and table2 when table1.B = table2.B then I want Table1.A value in Table2.FK column and when Table2.B have null value then I want to set -1 in Table2.FK column

I tried multiple query but not getting output

Improve this question
New contributor
Akash Khare is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
1
  • You want an outer join and you want to look at one of coalesce,nvl,isnull depending on your unknown RDBMS
    – Andrew Sayer
    48 mins ago

0

Reset to default

Your Answer

Akash Khare is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.