Table Join Query

[DHB]

I’ve linked two tables and am trying to create a report showing only the common references.

e.g.

Table1

Ref	Name
1	John
2	Sarah
3	Bill
4	Jane

Table2

Ref	Surname
2	Jones
3	Smith
4	Brown
5	White

Trying to create a table that shows;

Name	Surname
Sarah	Jones
Bill	Smith
Jane	Brown

But am getting;

Name	Surname
John
Sarah	Jones
Bill	Smith
Jane	Brown
	White

What have I done wrong?

Thanks in advance.

[David4F]

Hi,

If you are using M you just create an inner join between the two tables

Kind Regards

David 

[BhaveshPatel · Accepted solution]

Hi There,

You should select Inner Join which will get all the matching rows from both tables.

Inner Join