select order.order_id, product.product_name, ....
from order, product, order_product
where order.order_id = order_product.order_id and
order_product.product_id = product.product_id
order by order.order_id
from order, product, order_product
where order.order_id = order_product.order_id and
order_product.product_id = product.product_id
order by order.order_id