Ive tried relating both tables to eachother both ways and th

I\'ve tried relating both tables to eachother both ways, and the join is able to be made both times.
Please help?
For more clarification
I\'ve selected the Counties table as the main table with NAME as the field to base the join on. Choosen dating table as the table to pull from. And then selected NAME of the field to us from the dating table.

Solution

Here is the query need to be written to join both \'Counties\" and \"dating\" table.

Need to use \"INNER JOIN\" to achieve join the tables. we can select required columns before writing INNER JOIN and then after , write the condition on which attribute needs to match. In our condition it is \"Name\".

SELECT Counties.name
FROM Counties
INNER JOIN Dating
ON Orders.name=Dating.name;