Advertisement
Guest User

Untitled

a guest
Nov 23rd, 2014
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. SELECT * FROM Products WHERE Color = 'Black'
  2. AND IF (Item = 'Dresses', 1, 0) = 1
  3.  
  4. SELECT * FROM Products WHERE Color = 'Black'
  5. AND IF (Item = 'Dresses' (SELECT * FROM Products WHERE Price < '$300'), 1, 0) = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement