Query/Table question

B

Beto1967

I've two tables table A shows all the accounts with no survey ID that where
called this week. Table B shows all the accounts called YTD with survey ID I
need to combine both tables the like for like value is the account number..
The problem I have is that when I join them together I would like to show all
the data from table B and only the data that matchs from table A . For
example this is what I would like to see
Table A has phone number Table B has Phone number and survey ID
Phone number survey id and Phone number from table A
123 1 123
123 2
123 3
what I see now is
123 1 123
123 2 123
123 3 123
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top