list_orderlines

SELECT u.ID,u.LastName,L.product_ID,L.quantity,L.Total_of_all FROM users u
INNER JOIN orders o
ON u.ID = o.user_ID
INNER JOIN orderlines L
ON o.ID = L.order_ID;