Find three contacts from table using ID #s in another table

[KeithIT]

Today is one of those days where I can't seem to wrap my head around anything, so here goes.

I have a database where the contact information is linked to an agency name via a third table which has the contact ID# and agency ID#, and nothing else.

In a fourth table there is a list of programs with three contacts associated with each program, for simplicity sake let's just say contact1, contact2 and contact3.

I am trying to create a select query which will link (via relationships) the programs, which are associated with an agency, to the contacts table via the agency/contact join table. I am getting a complete listing of the programs and their contacts, however it is coming out like:

Program Name Contact1 Contact1 Contact1
Program Name Contact2 Contact2 Contact2
etc.

I have the query set up as follows:

Program name, Contact1, Contact2, Contact3

If you need more information let me know.
Keith

 

[mresann]

Try inserting DISTINCT in your SELECT statement. This will return only non-duplicative records.