Member Avatar for _taz_
_taz_ 0 Newbie Poster

I need help with a left outer join on a table and some queries (is it possible to outer join with queries?)

here's my SQL right now

SELECT Clients.ClientID, Clients.SSN, Clients.WholeName, Clients.Address1, Clients.Address2, Clients.City, Clients.State, Clients.ZIP, Clients.HomePhone, Clients.WorkPhone, Clients.OtherPhone, DPs.SumOfAmount AS [Client Down Payments_SumOfAmount], Remain.SumOfAmount AS [Client Remaining_SumOfAmount], [MF PTD].SumOfAmount AS [Monthly Fees PTD_SumOfAmount], Savings.SumOfReceiptAmount AS [Client Savings_SumOfReceiptAmount], ROH.ReceiptAmount, TPTD.SumOfReceiptAmount AS [Client Paid to Date_SumOfReceiptAmount]
FROM ((TPTD INNER JOIN (Savings INNER JOIN ([MF PTD] INNER JOIN (Remain INNER JOIN (DPs INNER JOIN Clients ON DPs.ClientID = Clients.ClientID) ON Remain.ClientID = Clients.ClientID) ON [MF PTD].ClientID = Clients.ClientID) ON Savings.ClientID = Clients.ClientID) ON TPTD.ClientID = Clients.ClientID) INNER JOIN Payments ON Clients.ClientID = Payments.ClientID) INNER JOIN ROH ON Payments.ClientID = ROH.ClientID;

I want to outer join so that I have rows for every client even if they are not in the other tables. I want my left table to be Clients and the common field in all is ClientID

table - Clients
Queries DPs,MF PTD,Remain, ROH, Savings, TPTD


thx!

  • 1 Contributor
  • 0 Replies
  • 114 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.