29 - Join Query Using Query (3 - Spring Data R2DBC)
В следующей лекции мы будем использовать приведенный ниже SQL. SELECT co.order_id, c.name AS customer_name, p.description AS product_name, co.amount, co.order_date FROM customer c INNER JOIN customer_order co ON c.id = co.customer_id INNER JOIN product p ON p.id = co.product_id WHERE p.description = :description ORDER BY co.amount DESC
В следующей лекции мы будем использовать приведенный ниже SQL. SELECT co.order_id, c.name AS customer_name, p.description AS product_name, co.amount, co.order_date FROM customer c INNER JOIN customer_order co ON c.id = co.customer_id INNER JOIN product p ON p.id = co.product_id WHERE p.description = :description ORDER BY co.amount DESC
