List products sold to buyers

freshonlineMax

Hi, I want to list cares sold to buyers from two tables : BuyersTable & ProductsTable I want to get below result : Buyer Product

Tom Benz
Bmw
Volvo
Jim Bmw
Benz

Tanks for help.

_Damian S_

You are looking at a simple inner join here between a few tables. I would assume your lecturer covered this. It will be in the form of: Select BuyerName, ProductName from tblBuyer inner join tblBuyerProduct on BuyerID = BP_BuyerID inner join tblProduct on BP_ProductID = ProductID order by BuyerName, ProductName This assumes you have a standard table setup - tblBuyer (for buyer details), tblProduct (for Product Details) and tblBuyerProduct to create a many to many link between Buyers and Products.

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! If you need a laugh, check out my Vodafone World of Difference application | If you like cars, check out the Booger Mobile blog | If you feel generous - make a donation to Camp Quality!!

freshonlineMax

Dear Friend Thank you for reply But i want to list products with none repeatitve buyers, all queries list data and repeat buyer's name at each row, I want result like below :

Buyer Product
Jack BMW
Benz
Volvo
Tom Benz
Toyota
Ed BMW
Volvo
Citruen

Please help...

_Damian S_

That becomes a formatting issue... how are you displaying the data to the users?

I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! If you need a laugh, check out my Vodafone World of Difference application | If you like cars, check out the Booger Mobile blog | If you feel generous - make a donation to Camp Quality!!

freshonlineMax

Hi It's good point, I want to show data in Crystal Report. Do you know any tutorial ?