FredixBlog

Quertion: I have a query I’m having a problem with. In SQL Server, a person can use a star next to a column so if there is no match it returns a null value. However, in Access it will not allow it. There are other conditions as well so I can not use a simple outer join. Here is an example.
Table A, Clients
Name, account, state
Table B, Accounts
Account, Registration
The example statement would be
select a.name, a.account from Clients a, account b where a.account=*b.account and a.state=’AZ’
What I want is if a client does not have an account then it shows up with a null value. What statements needs to be used in Access?
Fredix gave this response on 3/16/2002:
Hi!

Outer joins are possible in Access as well.
In the query builder, double-click on the relation line. A window with three options will pop-up. Choose the second or the third option, close the box and try your query.

I personnaly never understood the text describing the second and third option. Just give a try until the relation line shows an arrow on the table where there can be no related record (Account in your case).

Regards.