Home Forums SQL Server 2008 T-SQL (SS2K8) Using results of an EXCEPT query RE: Using results of an EXCEPT query

  • November 15, 2010 at 8:09 am

    #1250747

    Have you tried this?

    select PtID, MedID, GenericMedName, MedChange from dbo.Pyxis

    except

    select [Hospital #], BASEITEMNUMBER, '', '' from dbo.HMM

    order by pyxis.PtID

    Vishal Gajjar
    http://SqlAndMe.com