Re: LEFT JOIN Question


David Fabian wrote:
TableA TableB

Name ID_A ID_A MoreData
AAA 1 1 111
BBB 2 1 222
CCC 3

SELECT * FROM TableA
LEFT JOIN TableB ON TableA.ID_A = TableB.ID_A

The above returns:

Name ID_A MoreData
AAA 1 111
AAA 1 222
BBB 2 Null
CCC 3 Null

I am trying to pull TableB records WHERE MoreData != 111, so I used:

SELECT * FROM TableA
LEFT JOIN TableB ON TableA.ID_A = TableB.ID_A
WHERE MoreData != 111

Which returns:

Name ID_A MoreData
AAA 1 222

How can I get SQL Server to return these records?:

Name ID_A MoreData
AAA 1 222
BBB 2 Null
CCC 3 Null

Dave

SELECT * FROM TableA
LEFT JOIN TableB ON TableA.ID_A = TableB.ID_A
WHERE MoreData <> 111
OR MoreDate IS NOT NULL

.

Relevant Pages

  • Re: LEFT JOIN Question
    ... SELECT * FROM TableA ... LEFT JOIN TableB ON TableA.ID_A = TableB.ID_A ... Name ID_A MoreData ... I am trying to pull TableB records WHERE MoreData!= 111, ...
    (microsoft.public.sqlserver)
  • LEFT JOIN Question
    ... SELECT * FROM TableA ... LEFT JOIN TableB ON TableA.ID_A = TableB.ID_A ... Name ID_A MoreData ... I am trying to pull TableB records WHERE MoreData!= 111, ...
    (microsoft.public.sqlserver)
  • Re: LEFT JOIN Question
    ... Steve wrote: ... LEFT JOIN TableB ON TableA.ID_A = TableB.ID_A ... OR MoreData IS NULL ... SELECT * FROM TableA ...
    (microsoft.public.sqlserver)