Home Forums SQL Server 2014 Development - SQL Server 2014 Exclude result when at least one field is Y RE: Exclude result when at least one field is Y

  • June 22, 2016 at 11:52 am

    #1886357

    TheSQLGuru (6/17/2016)

    I would do it with an AND NOT EXISTS (SELECT ...) clause myself.

    As would I. 🙂

    select distinct item_id

    from jec_item_sup jis

    where supplier=77

    and not exists (select * from jec_item_sup where supplier=jis.supplier and item_id=jis.item_id and primary_supplier='Y')