Pid Amount ------------------------- 1 2000 2 3600 3 500
Pid ProductId Amount --------------------------------- 1 101 1000 1 102 500 1 103 500 2 105 1600 2 101 2000 3 109 500
SELECT Bill.Pid, BillData.Amount, BillData.ProductID FROM Bill INNER JOIN BillData ON Bill.Pid = BillData.Pid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)