In the following query, and I am able to successfully pull all the necessary information in sql developer.
I would like to pull some information from another table in another database.
FROM MSCM.default_user_location_type dfl,
WHERE usr.USER_ID = dfl.user_id (+)
AND dfl.location_type_id = lty.location_type_id
AND dfl.location_id = loc.location_id
--AND usr.emp_id_varchar = '20771'
ORDER BY usr.user_id,
I tried adding the following code in the from section, but it didn't work.
Any suggestions on how I can get this to work?