Skip to content

Instantly share code, notes, and snippets.

@cwhite92
Created December 10, 2014 01:20
Show Gist options
  • Save cwhite92/48ad7fb5538280eff5ee to your computer and use it in GitHub Desktop.
Save cwhite92/48ad7fb5538280eff5ee to your computer and use it in GitHub Desktop.
Upload new image select list conditional
SELECT NAME, P.PRODUCT_ID FROM PRODUCTS P
LEFT JOIN IMAGES I ON P.PRODUCT_ID = I.PRODUCT_ID
WHERE I.PRODUCT_ID IS NULL
AND ARCHIVED = 'N'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment