Joining data to display information that is the same 1

[Herdrich]

I am trying to compare two databases against each other
and have the data that is the same be displayed. I can get the SQL code to run if it is only last name or first name but cannot figure out how to make it check that both the first and last name match then displaying the information. The code bellow is what i am trying to accomplish but it will not run for me any help would be grate.

 SELECT [Mass List].[Last Name], [Mass List].[First Name]
FROM [Mass List] INNER JOIN Query ON [Mass List].[Last Name], [Mass List].[First Name] = Query.[Last Name], [Mass List].[First Name];

Thanks,
Glenn

 

[Herdrich]

SELECT [Mass List].[Last Name], [Mass List].[First Name]
FROM [Mass List] INNER JOIN Query ON [Mass List].[Last Name], [Mass List].[First Name] = [Query].[Last Name], [Query].[First Name];

 

[PHV]

SELECT [Mass List].[Last Name], [Mass List].[First Name]
FROM [Mass List] INNER JOIN Query ON [Mass List].[Last Name] = Query.[Last Name] AND [Mass List].[First Name] = Query.[First Name]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Herdrich]

Awesome looks so simple now. Thx