Hello Tina,

I wrote a sql that matches your requirement but I have not tried it using PS query. As a sample, I took PSOPRDEFN (having OPRID and EMPLID fields) record and a custom record PS_ROLEUSER_SP (having ROLEUSER, ROLENAME and EMPLID fields). Attached is the query:
****************************************************
SELECT A.OPRID, A.EMPLID, B.ROLEUSER, B.EMPLID
FROM PSOPRDEFN A
LEFT JOIN PS_ROLEUSER_SP B
ON A.OPRID = B.ROLEUSER
UNION ALL
SELECT A.OPRID, A.EMPLID, B.ROLEUSER, B.EMPLID
FROM PS_ROLEUSER_SP B
LEFT JOIN PSOPRDEFN A
ON A.OPRID = B.ROLEUSER
WHERE A.OPRID IS NULL;
*******************************************************
With this query I am able to get the rows that have corresponding rows in the other record as well as those rows that does not match with each other (thus showing a NULL value in the fields).

I will try to get any other possible solutions if I come across.