Hello: I have one table with customer info (name, address...) and another one with the products purchased by each costumer. I linked both tables by costumer ID.
I want to create a view for each costumer to show at the top of the view the costumer information (name, address...) and then the list of the products purchased by the costumer.
Example:
John Williams Phone 4242-5478 Adress: 25 1st street
----------------------------------------------------------------------------------------------------------
Products purchased
Car
House
Plain
Antartic Continent
How can I build this view?
Thank you