Multiple returns from same record

[Lamb2087]

I have a query that will eturn the same exact data multiple times(4x) rather than just once, is there a way such as a criteria etc. to have only once instance of a record come back when you run the query rahter than four instances of the same exact record?

 

[wh00t]

check the way the tables for the query are linked

 

[Lamb2087]

Table links

I tried different scenarios as to they way they were linked and did not get an answer. Is there something I could put in the criteria of a field to bring back what I want?

 

[wh00t]

other parts of your db may not function correctly if the tables aren't linked correctly to begin with

list here how u have the tables linked

 

[Lamb2087]

Table Link

SELECT dbo_RifleInventory.PEOPLE_ID, dbo_RifleInventory.SERIAL, dbo_RifleInventory.SLOT, dbo_RifleInventory.DRILL_TEAM, dbo_RifleInventory.JR_OR_SR, dbo_PEOPLE.FIRST_NAME, dbo_PEOPLE.MIDDLE_NAME, dbo_PEOPLE.LAST_NAME, dbo_RESIDENCY.DORM_PLAN, dbo_RESIDENCY.DORM_ROOM
FROM (dbo_RifleInventory LEFT JOIN dbo_PEOPLE ON dbo_RifleInventory.PEOPLE_ID = dbo_PEOPLE.PEOPLE_ID) LEFT JOIN ((dbo_RESIDENCY LEFT JOIN dbo_ABT_SETTINGS ON dbo_RESIDENCY.ACADEMIC_YEAR = dbo_ABT_SETTINGS.SETTING) LEFT JOIN dbo_ABT_SETTINGS1 ON dbo_RESIDENCY.ACADEMIC_TERM = dbo_ABT_SETTINGS1.SETTING) ON dbo_PEOPLE.PEOPLE_CODE_ID = dbo_RESIDENCY.PEOPLE_CODE_ID
WHERE (((dbo_ABT_SETTINGS.AREA_NAME)='ACA_RECORDS') AND ((dbo_ABT_SETTINGS.LABEL_NAME)='CURRENT_YEAR') AND ((dbo_ABT_SETTINGS1.AREA_NAME)='ACA_RECORDS') AND ((dbo_ABT_SETTINGS1.LABEL_NAME)='CURRENT_TERM'));

 

[Lamb2087]

What should show up in query

When you run the query the id,serial,slot,drillteam,jr or sr, first name, middle name, last name,dorm plan, dorm roomshould show up for each person. Currently I am getting all this information four times or two times rather than just one time for each person.

 

[Lamb2087]

Data comes back twice

After reviewing the results of the query the data comes back two times for each record. I only need to it to come back once.