Link table to itself 1

[CRilliterate]

Hi,
I need to join table back to itself to retrieve Business and Individual records.
When I linked SQL SErver tables to CR10 I can only link it once? Is there way? Thanks

 

[synapsevampire]

Add the table in again, it will prompt for an alias.

-k

 

[CRilliterate]

Thanks