I have a database with 100s of tables but there are three I need to extract data from:
What I want to do is output the following:
DN (from BWAS.DN), USER_UID (from BWAS.AS_USER), SVC_PROVIDER_ID, SUPPORT_EMAIL (both from BWAS.SVC_PROVIDER)
but only when the USER_UID field in BWAS.DN is not null
I'm not sure how to tie the three tables in together. I can get the output from two tables not three.
Any help would be gratefully received.
I think you are looking for something like this:
from BWAS.AS_USER AU,
where DN.USER_UID is not null
and DN.user_id = AU.user_id
and DN.svc_provider_uid = SP.svc_provider_uid;