Joins

[Cyndi]

Ok here is my question - I am linking to a database that is already
done and is protected so I cant change what comes from it

In it is a season owner field and a horse owner field and these are id
fields both tied to client id in the client table

how can i write a query to bring in the seasonownername and the mare
name and they both be on client id??

 

[John Vinson]

Ok here is my question - I am linking to a database that is already
done and is protected so I cant change what comes from it

In it is a season owner field and a horse owner field and these are id
fields both tied to client id in the client table

how can i write a query to bring in the seasonownername and the mare
name and they both be on client id??

Create a query adding the Client table TWICE - once linked to
seasonowner ID, once linked to horse owner ID.