Advertisement
Guest User

Untitled

a guest
Jun 19th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.50 KB | None | 0 0
  1.                 SELECT *
  2. FROM website_vraag_antwoord
  3.                 INNER JOIN website_products ON website_vraag_antwoord.wva_id = website_products.wva_id
  4.                 INNER JOIN producten ON producten.p_id = website_products.p_id
  5. WHERE wva_titelNL = 'Thuis'
  6. AND wva_online = 1
  7. AND
  8. (
  9.                 website_products.p_id IN (SELECT p_id FROM website_products WHERE wva_id = 11)
  10.                 AND
  11.                 website_products.p_id IN (SELECT p_id FROM website_products WHERE wva_id = 9)
  12.  
  13. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement