niche Posted July 6, 2018 Share Posted July 6, 2018 This code works with cols that are not concatenated: SELECT item3 FROM nconnectz t1 WHERE NOT EXISTS ( SELECT item3 FROM itemandsize t2 WHERE t1.item3 = t2.item3 ) GROUP BY item3 I think this is the same query with concatenated columns SELECT CONCAT_WS(',', itemandsize, pkg_quantity) item4 FROM nconnectz t1 WHERE NOT EXISTS ( SELECT CONCAT_WS(',', itemandsize, '0.00') item4 FROM itemandsize t2 WHERE t1.item4 = t2.item4 ) GROUP BY item4 the error is: Unknown column 't1.item4' in 'where clause' what's causing the error? Link to comment Share on other sites More sharing options...
niche Posted July 6, 2018 Author Share Posted July 6, 2018 Voila ! SELECT nconnectz.itemandsize, nconnectz.pkg_quantity FROM nconnectz WHERE NOT EXISTS ( SELECT * FROM itemandsize WHERE CONCAT_WS(',', nconnectz.itemandsize, nconnectz.pkg_quantity) = CONCAT_WS(',', itemandsize.itemandsize, '0.00') ) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now