Advertisement
Guest User

Nouf

a guest
Jan 20th, 2020
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. Select si.*,T.DistributorID from SalesInvoice si
  2. INNER JOIN
  3. (Select ThanaID,DistributorID=MAX(DistributorID) from BusinessPartnerLocation bpl Group by ThanaID) T ON si.ThanaId=T.ThanaID
  4. Where T.DistributorID>0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement