Lines duplicated with Queries

[mari_hitz]

Hi!
I have a database with two tables and I have performed a query that returns me the values of table one that are not included in table two. The data is from several people and they only appear once in table one and also in table two, however the query returns me several lines for each individual. Do you have any idea why this is happening?

Thanks!

[alansidman]

Suggest you post your SQL statement. Difficult to diagnose without that information.

[mari_hitz]

Thanks! Here it is what appears on SQL:

SELECT SRR.conca, SRR.[Personnel Number], SRR.[First Name], SRR.[Last Name], SRR.[Home Country], SRR.[Host Country], SRR.[Assignment Start Date], SRR.[Assignment End Date], SRR.[TOTAL DAYS], SRR.[GENERAL CONTROL], SRR.[DAYS OUT OF ASSIGNMENT], Immigration.[Expired with NO action ]
FROM SRR INNER JOIN Immigration ON SRR.conca=Immigration.conca;

Am I missing something?

[alansidman]

Try changing the Join from INNER to LEFT

SELECT SRR.conca, SRR.[Personnel Number], SRR.[First Name], SRR.[Last Name], SRR.[Home Country], SRR.[Host Country], SRR.[Assignment Start Date], SRR.[Assignment End Date], SRR.[TOTAL DAYS], SRR.[GENERAL CONTROL], SRR.[DAYS OUT OF ASSIGNMENT], Immigration.[Expired with NO action ]
FROM SRR LEFT JOIN Immigration ON SRR.conca=Immigration.conca;

This will give you every record from the SRR table and only those records from the Immigration table where there is a conca record.

Alan