I have two tables with a Text data type as the common field between them.
I have created this query in SQL 2005:-
SELECT *
FROM [Table_A] A
INNER JOIN [Table_B] B
ON A.[EmailAddress] = B.[EmailAddress]
WHERE A.[FieldA] = B.[FieldB]
There is 1 record on Table_A with email (someone@this.com) and 3 records on Table_B with email (someone@this.com).
When I run the query I was expecting 3 records in my result, but only get one.
Any assistance with what I am missing would be appreciated.
Aucun commentaire:
Enregistrer un commentaire