Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT count(obj_id) as 'In Stock'
- FROM SHEET_INVENTORY s
- INNER JOIN SHEETS h on s.variant_id = h.variant_id and s.size = h.size
- INNER JOIN VARIANTS v on h.variant_id = v.variant_id
- INNER JOIN CUT_SIZES c on h.size = c.cut_id
- WHERE sheet_type = 'Glass' AND name = 'tangerine orange' AND height = 35 AND width = 20;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement