Advertisement
Guest User

Untitled

a guest
Apr 10th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.63 KB | None | 0 0
  1. Select * From   salSalesPriceHistory
  2. Where FromSourceTag=10522 And BillDate=20190331
  3.  
  4. Select A.FromBillNo,* From arSellInvoice A
  5. Where A.BillNo in('VI1904100003','VI1904100004')
  6.  
  7. Select *
  8. From arSellInvoiceMaterial B
  9. Where B.BillNo in('VI1904100003','VI1904100004')
  10.  
  11. Select *
  12. From arSellInvoiceDetail C
  13. Where C.BillNo in('VI1904100003','VI1904100004')
  14.  
  15.  
  16. Select *
  17. From arSellInvoiceQuery D
  18. Where D.BillNo in('VI1904100003','VI1904100004')
  19.  
  20. Select *
  21. From arSellInvoiceBalanceInfo E
  22. Where E.BillNo in('VI1904100003','VI1904100004')
  23.  
  24.  
  25. Select * From MedSellInvoiceMsg
  26. Where BillNo in('VI1904100003','VI1904100004')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement