Joining a table twice in Crystal

[Shevy]

Hi,

I am trying to write a crystal report. I am trying to accomplish the following:
I have a table called SPCODE which has codes in it for each client spcode joins to the client table by client_id. Now I need to join the spcode table to a different table with title orders. but the title orders can be joined by the "Marketingrep" field OR by the "BuyersAttorney" field.

SPCODE CLIENT
Client_ID-------------> CLient_ID
CODE Other client Info

Title
MarketingRep
BuyersAttorney


I tried creating to instances of the spcode table and 2 instances of the title table and joining one by code to marketing rep and one by code to buyersattorney. However it is only bringing in the files that are connected by markenting rep.

IS it possible to do what I am trying to accomplish?
ANY HELP WITH THIS WILL BE GREATLY APPRECIATED!

Thanks.

[brucevde]

The report would need one instance of the Title table and two instances of the SPCode table. Link/join the MarketingRep field to one instance and the BuyersAttorney field to the other instance. If the two Title fields are not required, ie one or both can be null, make sure you use Left Joins.