Joining on null values - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Joining on null values

Author

Topic

jportnoy
Starting Member

7 Posts

Posted - 2006-09-29 : 10:07:41

I have the following setup:

Table A:
<key>, 1, 2
<key>, 1, NULL

Table B:
<key>, 'foo'
<key>, 'bar'

The values "1, 2" in Table A link to the <key> in Table B.

I currently have the tables joined via an inner join. However, when there's a null value (record 2), that record doesn't show up in my query.

Any suggestions?

cjcclee
Starting Member

33 Posts

Posted - 2006-09-29 : 10:19:42

tabel A left outer join table B

jportnoy
Starting Member

7 Posts

Posted - 2006-09-29 : 10:34:33

quote:
Originally posted by cjcclee

tabel A left outer join table B

Thanks a bunch.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources