I am beginners in MS Sql, now I have three tables (Companies, Product, SaleBody). and their fields are
(CompanyId, CompanyName), (ProductId, ProductName, CompanyId, PurchaseSTPrice, TradePrice), (SerialNo, SaleId, ProductId, Quantity, Price, TotalPrice)..............
I want to create Report in which I want (companies.CompanyName, product.ProductName, product.TradePrice, salbody.TotalPrice)
How can I get these fields from 3 tables. I am very thankful to you all..... and wait for your reply