Advertisement
Guest User

Untitled

a guest
Mar 18th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. SELECT count(obj_id) as 'In Stock'
  2. FROM SHEET_INVENTORY s
  3. INNER JOIN SHEETS h on s.variant_id = h.variant_id and s.size = h.size
  4. INNER JOIN VARIANTS v on h.variant_id = v.variant_id
  5. INNER JOIN CUT_SIZES c on h.size = c.cut_id
  6. WHERE sheet_type = 'Glass' AND name = 'tangerine orange' AND height = 35 AND width = 20;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement