Outer Joins on multiple tables
Posted on 2008-06-25
I am trying to run a query using MSQuery off a Cache 5.2.3 database, and am having an issue creating an outer join becuase the query requires 3 separate tables. When I try to change one of the inner joins to an outer join it tells me that I can't have an outer join with three tables. How can I get around that? Here is the sql code it is running (I have changed table names, and field names for security purposes)...
SELECT ACCT1.acn1, ACCT1.mbr_1st_nam, Demographics.MMNAM, ACCT1.mbr_lst_nam, Demographics.MNSUF, ACCT1.addr_line1, ACCT1.city, ACCT1.state, ACCT1.zip, ACCT1.mbr_ssn, CCT.Credit_Card_Number
FROM SQLUser.CCT CCT, SQLUser.Demographics Demographics, SQLUser.ACCT1 ACCT1
WHERE Demographics.acn = ACCT1.acn AND CCT.acn = Demographics.acn AND CCT.acn = ACCT1.acn
The question is, how exactly can I create an outer join so that I return ALL accounts from any table? If I remove the joins wouldn't I just get redundant information?