Friday, October 4, 2013

how to create an sql query to getting profit of each product

I want to get data from both tblPurchase and and tblSales


and i have a lot of data in both tables and ProductID's repeat again and again in both tables then how to get each product PurchasePrice against its salesprice in a query ?


No comments:

Post a Comment