[RESOLVED] Nested queries

[rixkid]

hey guys!
Need help how to construct the mysql query for the following, i have illustrated my db tables and output html table on the jpg attached file.

Thanks in advance for your help.

[bretticus]

You need to use join syntax.

Depending on how you need to make a join, there are different methods to accomplish this. You probably just need a CROSS or INNER join.

Here's one simple tutorial using table references for a an implied cross join. I prefer using INNER JOIN in my queries. You can do whatever makes the most sense and works for you (you may also wanna read up on performance debates.) Here's a more comprehensive tutorial.

[rixkid]

Thanks i have solve it using the following:

SELECT orders.id, orders.payment, orders.date, orders.status,
SUM(orderitems.price * orderitems.quantity) total_price,
GROUP_CONCAT(products.product SEPARATOR '<br>')productBy
FROM orders, orderitems, products
WHERE orderitems.orderID = orders.id AND products.productID = orderitems.productID
GROUP BY orders.id, orders.payment, orders.date ORDER BY orders.id DESC