Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select
- s.[Client],
- s.[Company],
- s.[SupplierNo],
- h.[LastERPHelperID]
- from dbo.vDUNS_LastERPSupplier as s
- full outer join dbo.[LastERPHelper] as h
- on h.SupplierNumber = s.SupplierNo AND
- h.Client = s.Client AND
- h.Company = s.Company
- where h.LastERPHelperID in (
- 432231,
- 496359,
- 76322)
- order by LastERPHelperID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement