Linked Tables and returning blanks

[joreyn]

Hi All,



I have a table which has an ID number in it and I have linked it to another table to pull through matching data like a name. I am looking to have the list of ID's for the day and when I run the query the full list of ID's is in the return regardless whether it pulls information through or not. So for example, say I have ID's 000123, 000456, 000789, 001230 & 004560 and I want to find a customer name for each of them but a name might not exist, how can I get all query to return each of the ID's some with names, some without but all in the same order? so it would look like this:

Customer ID	Customer Name
000123	Mr Fred Jones
000456	Mrs Mary Smith
000789
001230	Mr John Frank
004560

Any help would be appreciated as a Google search didn't help

Thank you in anticipation

[NoellaG]

Hi,

you need an outer join to do this:

select [ID], [CustomerName], ... from [tableName1] left outer join [tableName2] on [tableName1].[ID] = [tableName2].[NameForeignKeyField]

kr
NG