Inner Join

SUBMITTED BY: openeyes

DATE: April 23, 2016, 8:24 a.m.

FORMAT: SQL

SIZE: 312 Bytes

Raw Download

HITS: 7485

Report
  1. Update tbl_product_store set Store_Remain=tbl_product_store.Store_Remain + @quantity from tbl_product_store inner join tbl_product_sale_market_final on tbl_product_sale_market_final.Barcode = tbl_product_store.Barcode WHERE tbl_product_sale_market_final.Barcode=@Barcode AND tbl_product_sale_market_final.No=@No
comments powered by Disqus