How to search for every field entry from one table to another

[sylbaryn]

Hi. I've had a look through the site but can't find an answer. I apologise if I'm just not looking up the right thing.

If you could point me in the right direction I would be most grateful.

OK, I have two tables. They contain different information but each has a first name, last name and date of birth field. I want to pull out the rows in each table where there's a cross table match of first name, last name and DOB.



Any help would be much appreciated. Just point me in the right direction.

Thank you

[orange]

This is the type of query involved.

Select table1.*, table2.*
FROM table1,table2
WHERE 
table1.FName = table2.FName AND
table1.LName = table2.LName AND
table1.DOB =table2.DOB

I suggest you do NOT have spaces in field names.

Good luck.

[sylbaryn]

That simple eh! I knew I was overthinking it. Thanks for your help. Much appreciated.