[RESOLVED] [Crystal]Custom data in Join

[kfcSmitty]

I have a query that pulls the data I want:

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

b.Type_Id = '5'

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?

[kfcSmitty]

As far as I could find, you cannot do it in the database expert.

I accomplished it by going in and creating a new connection. Then, within the connection I added a command, which I pasted my query in and I was able to copy the fields from there.