[eluser]patie[/eluser]
[quote author="WanWizard" date="1280954645"]If that is the case there is no need for a third table.
What do you intend to do with the Order_album table. Where does that fit into the picture?[/quote]
i dont want third table but i dont know how i join USER with ORDER
user
id
name
surname
...
order
id
user_id
status
...
order album
id
order_id
album_id
...
album
id
name
price
...
in this context...
Code:
SELECT user.*, order.*, SUM((order_album.price)*order_album.quantity) AS price
FROM order_album
LEFT JOIN order ON order_album.order_id = order.id
LEFT JOIN user ON order.user_id = user.id
GROUP BY order_album.order_id
ORDER BY order.id DESC
because i need order info, user info and price of order