sql server 2008 - SQL - Query - where not in select -

sql server 2008 - SQL - Query - where not in select -

okay here sql:-

select telephone, houseno, street, tostreet, passengername, acceptancedate telephone acceptancedate !> '2014/05/01' , telephone '011%' , ( zoneno = '6' or zoneno = '5' or zoneno = '9' or zoneno = '108' ) , telephone = 'xxx' order acceptancedate

this displays 5 records phone number.

however, if alter !> >

it shows 3 records.

the sql have correct, want display numbers if telephone number doesn't appear when acceptancedate > '2014/05/01' (as phone numbers not unique)

any help much appreciated!

you utilize not exists exclude telephone numbers appear after date

select telephone, houseno, street, tostreet, passengername, acceptancedate telephone t telephone '011%' , zoneno in ('6', '5', '9', '108') , telephone = 'xxx' , not exists ( select 1 telephone t2 t2.telephone = t.telephone , t2.acceptancedate > '20140501' );

sql sql-server-2008