sorry for this dumb question .. but how can I show the products ( description , serial number, price ) purchased by the customer "Peacock cafe bar"
in the picture i show 3 tables
i have try with
As I remember you should use joint query on your tables, something like:
select * from ProductsTable as Products join on (select Buys.ProCode* from CustomerTable as Customer join BuysTable as Buys on Customer.code = Buys.custcode) as customerbuys on Products.code = customerbuys.ProCode