Re: LEFT JOIN Question

Steve wrote:

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

Last line should be
OR MoreData IS NULL

Here's a third way to do it:

SELECT * FROM TableA
LEFT JOIN TableB ON TableA.ID_A = TableB.ID_A
WHERE COALESCE(MoreData,0) <> 111
.

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)
  • 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)
Loading