Outer join/Null possibility

E

Evan McCutchen

Hello,

I am looking to create an outer join, where the second table in my relation
may be null. I received a response from Vanderghast a few days ago, but I am
still confused as to how to do this. Can someone direct me?

Thanks!
Evan M.
evan AT radiologyonesource DOT com
 
A

Allen Browne

Open your query in design view.
Presumably you see two table, with a line joining them.

1. Double-click the line.

2. Access pops up a dialog box with 3 options.
Choose option 2 or 3.
 
E

Evan McCutchen

Allen,

This works, except for the fact that i may not have any records in one
table. My situation is this - I have a companies table and a reps table. i
want to be able to use a query to find anybody within either of those
tables. As of now, if a company doesn't have any related reps, then I don't
receive any results. I've chosen both options 2 & 3 and still receive no
results. That is why i was looking to see if someone could help me with the
"null" option

Evan M.
evan AT radiologyonesource DOT com
 
E

Evan McCutchen

Todd,

That's what my SQL looks like now, but I still can't make it work. I'm
puzzled. Thanks for your assistance though!

Evan M.
evan AT radiologyonesource DOT com
 
Top