Advertisement
Guest User

Untitled

a guest
Feb 9th, 2016
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.33 KB | None | 0 0
  1. select
  2.     s.[Client],
  3.     s.[Company],
  4.     s.[SupplierNo],
  5.     h.[LastERPHelperID]
  6. from dbo.vDUNS_LastERPSupplier as s
  7. full outer join dbo.[LastERPHelper] as h
  8.     on h.SupplierNumber = s.SupplierNo AND
  9.         h.Client = s.Client AND
  10.         h.Company = s.Company
  11. where h.LastERPHelperID in (
  12.         432231,
  13.         496359,
  14.         76322)
  15. order by LastERPHelperID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement