I have written the following except query...
select PtID, MedID from dbo.Pyxis
select [Hospital #], BASEITEMNUMBER from dbo.HMM
order by pyxis.PtID
I want to add more fields from the Pyxis table to the results of this query. Anyone have any suggestions of the best practice to do this? Should I just copy the results to another table and run another query, or can this somehow be nested? Thanks!