I am trying to display information from various fields on a per client basis. In some instances a client will have no entries in a column, sometimes they will have one or more. I don't want to end up with any duplicate rows.
I've tried various combinations of parent and child groupings but can't get it to look the way I want.
SELECT DISTINCT
E.EntCode AS [Member],
A.Reference AS [Fixed Assets],
C.Reference AS [Cash],
L.Reference AS [Loans]
FROM
dbo.CR_Entity AS E
LEFT OUTER JOIN dbo.CR_FixedAssets AS A ON E.EntCode = A.EntCode
LEFT OUTER JOIN dbo.CR_Cash AS C ON E.EntCode = C.EntCode
LEFT OUTER JOIN dbo.CR_Loans AS L ON E.EntCode = L.EntCode
WHERE E.Status = '0'
