Good Day Experts!
I am having a bit of trouble with a recent request for data from our database. SQL query writing is not my strong suit so please bear with me.
I have data in my main table A. I have a field that I can go to another table to get address information. Seems easy enough. Problem is that when I go to get the address information my record count increases. I thought it would get the address data and put in on the same record as the main table information. Here is the query:
[Main Contact Phone],
I get 17,519 records. Then I try to get address information with qury below and I get 18,634 records. Here is that query:
A.[Main Contact Phone],
[Carrier Profiles] A, [Carrier Remittance Addresses] B
A.SCAC = B.SCAC
What am I doing wrong?