Outer join/Null possibility

  • Thread starter Thread starter Evan McCutchen
  • Start date Start date
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
 
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.
 
Try looking at the SQL.


Select MainTable.fields, MayBeNullTable.fields
from MainTable left join MayBeNullTable on MainTable.key =
MayBeNullTable.key

-Todd
 
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
 
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
 
Back
Top