Query - like

[advpay]

I need to get just the street that is unique to the actual address so it should end up like this:<br><br>Expr1:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DU11801:&nbsp;&nbsp;&nbsp;CustomerID:<br>Smith St&nbsp;&nbsp;&nbsp;&nbsp;Smith St&nbsp;&nbsp;&nbsp;&nbsp;000444444<br><br><br>I have two tables Customer which houses The CustomerID plus an address ex. data 124 Smith St<br><br>I also have a table <br>tblStreetunq which has a field called (DU11801) ex. data Smith St<br><br>Here is the sql I am using but I only get 29 rows and s/b getting 18,000<br><br><br><br>SELECT Customers.[Premise Address] AS Expr1, tblStreetunq.[DU11801 Field], Customers.CustomerID<br>FROM tblStreetunq, Customers<br>WHERE ((([Customers].[Premise Address]) Like [tblStreetunq]![DU11801 Field]));<br>