I have the following SQL that returns the records as I expected:
IF a.USERID=b.USERID AND b.CUSTID=c.CUSTID then return the records. Well what if I wanted to return all the records from
TMOSER.CZCS_USERS a and TMOSER.CZCS_CUSTOMERS c even if there are no records in TMOSER.CZCS_PWR_USER_CUSTID b?
SELECT a.USERID, c.CUSTID, b.DEFAULT_NPC, a.USER_NAME,
a.FIRST_NAME, a.LAST_NAME, a.UPDATE_USERID, a.USER_EMAIL, c.CUSTOMER_NAME,
c.LOGO_PATH, c.NPC, c.ISACTIVE
FROM TMOSER.CZCS_USERS a, TMOSER.CZCS_PWR_USER_CUSTID b, TMOSER.CZCS_CUSTOMERS c
WHERE a.USERID=b.USERID AND b.CUSTID=c.CUSTID