Null Value in Linking Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble hooking two tables together because one of the tables can
have null values in the field that I would like to join on. Is there a way
in SQL that if a value is null that join is not exercised?
 
I am having trouble hooking two tables together because one of the tables can
have null values in the field that I would like to join on. Is there a way
in SQL that if a value is null that join is not exercised?
Click to expand...

ummm... if a value is null, the join ISN'T execised.

Could you post the SQL of the query, and any error messages (or the
undesired outcome) that you're getting??

John W. Vinson[MVP]
 
John thanks for you help. I figured out a way the user could modify some
values to get around the problem we were having.

Thanks again.
 
Back
Top