Joins

  • Thread starter Thread starter Cyndi
  • Start date Start date
C

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??
 
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??
Click to expand...

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