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

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

Steve wrote:

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

"Steve" <morriszone@hotmail.com> wrote in message news:1169943209.032847.130730@v33g2000cwv.googlegroups.com...
>
> SELECT * FROM TableA
> LEFT JOIN TableB ON TableA.ID_A = TableB.ID_A
> WHERE MoreData <> 111
> OR MoreDate IS NOT NULL