Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select si.*,T.DistributorID from SalesInvoice si
- INNER JOIN
- (Select ThanaID,DistributorID=MAX(DistributorID) from BusinessPartnerLocation bpl Group by ThanaID) T ON si.ThanaId=T.ThanaID
- Where T.DistributorID>0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement