I have a query that pulls the data I want:
Code:
SELECT a.Name, c.Description
FROM AMGR_Client_Tbl AS a LEFT OUTER JOIN
AMGR_User_Fields_Tbl AS b ON a.Client_Id = b.Client_Id AND a.Contact_Number = b.Contact_Number AND b.Type_Id = '5' LEFT OUTER JOIN
AMGR_User_Field_Defs_Tbl AS c ON b.Type_Id = c.Type_Id AND b.Code_Id = c.Code_Id
WHERE (a.Record_Type = '31')
I have it reproduced in Crystal Reports with the exception of
In the first join. Is there a way to hard code this value into crystal reports for the join or will I have to create a view and run the report off that?