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