Need SQL query to include when NULL

Question

This query works perfectly and creates my temporary table with all the necessary columns, but I also want it to include rows when column 3 is NULL (currently it only gives me rows when column 3 has data in it).

  SELECT column1
        ,column2
        ,column3
        ,column4
        ,column5
  FROM Table1 
  INNER JOIN Table2
  ON table1.column3 = table2.column3

I have tried different statements such as AND, OR, which did not work. It is possible that I simply did not apply the statement correctly as I am a beginner. Whenever I try something it either gives me 0 rows or hundreds of thousands more than it should.

Your help is appreciated.

Anthony Grist · Accepted Answer · 2013-02-01 15:28:02Z

1

You could use a LEFT JOIN to return all rows from Table1, even when there isn't a match in Table2:

SELECT column1
    ,column2
    ,column3
    ,column4
    ,column5
FROM Table1 
LEFT JOIN Table2
ON table1.column3 = table2.column3

answered Feb 1, 2013 at 15:28

Anthony Grist

38.4k8 gold badges64 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Lamak · Accepted Answer · 2013-02-01 15:24:16Z

1

This is an answer so short that it maybe should be a comment, but.....change your INNER JOIN with a LEFT JOIN

answered Feb 1, 2013 at 15:24

Lamak

70.8k12 gold badges119 silver badges119 bronze badges

Comments

Khan · Accepted Answer · 2013-02-01 15:24:37Z

0

What you're looking for is a LEFT JOIN rather than your INNER JOIN:

  SELECT column1
        ,column2
        ,column3
        ,column4
        ,column5
  FROM Table1 
  LEFT JOIN Table2
  ON table1.column3 = table2.column3

answered Feb 1, 2013 at 15:24

Khan

18.2k5 gold badges52 silver badges60 bronze badges

Collectives™ on Stack Overflow

Need SQL query to include when NULL

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related