Advertisement
Guest User

Untitled

a guest
Aug 24th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.71 KB | None | 0 0
  1. SELECT
  2.        customerName
  3. FROM
  4.      orders  JOIN customers
  5. WHERE
  6.       orders.customerNumber=customers.customerNumber
  7. AND
  8.       orders.orderNumber IN(
  9.         SELECT
  10.                orders.orderNumber
  11.         FROM
  12.              orderdetails JOIN orders
  13.         ON
  14.               orders.orderNumber=orderdetails.orderNumber
  15.         AND
  16.               orderdetails.productCode IN(
  17.                 SELECT
  18.                        products.productCode
  19.                 FROM
  20.                      products JOIN orderdetails
  21.                 ON
  22.                   products.productCode = orderdetails.productCode
  23.                 AND
  24.                   products.productLine='Motorcycles'
  25.                       )
  26.        );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement