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