Hi There,

I am just a beginner with VB.NET; this is regarding a query about database join.

I have two tables in my database, one made as a master table and that we can call as ‘tbl_Master’ , the other one has got a grocery list in it and that we can call ‘tbl_groceries’.

For example,

A shopping cart program,.

Person A wants to buy some groceries, and I want create a record for Person A that he is buying groceries, like in the first column ‘Persons’ and second ‘Items’. So in first column will be adding Person A, and in the second one will be adding the ID’s of items for the other list tbl_groceries.

The same thing I want to retrieve to a DataGrid with detailed like “| Person A |Tea, Sugar, Coffee|”

So this is my concept, please can I have some hint how to make it happen,

Thank you,