SHARE
TWEET

Untitled

a guest Jun 19th, 2019 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select product.product_id, category.category_id, product.name, category.description
  2. from product , category
  3. inner JOIN category_prodcut ON category.category_id = category_prodcut.category_id
  4. inner JOIN category_prodcut ON product.product_id = category_prodcut.product_id;
  5.      
  6. select product_id from product;
  7.      
  8. select p.product_id, c.category_id, p.name, c.description
  9. from category_product cp join
  10.      product p
  11.      on p.product_id = cp.product_id join
  12.      category c
  13.      on c.category_id = cp.category_id;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top