Query/Table question

[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

 

[Ofer Cohen]

Have a look at this link on "Query Joins - Inner & Outer Joins"

http://www.databasedev.co.uk/query_joins.html