jeudi 25 février 2016

SQL 2005 Inner Join Query

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