pcsoft.us.windevCopyright 2026, PC SOFT28 Oct 2016 00:07:00 Z27 Oct 2016 03:18:00 ZHi I have to find barcode records which are not linked to a stockcode so I have the following querySELECT STKPLU.plu FROM STKPLU WHERE NOT EXISTS ( SELECT * FROM stkmast m join stkplu p on (p.stkm_linkid = m.sysid) ) This query returns 0 records. The STKPLU file contains 16,335 records which is also what I get if I remove the NOT. If I run the sub-query on its own I get 16,031 records. The difference between the 2 is what I would expect my query to return. What am i missing? Thanks David30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60147/read.awp28 Oct 2016 00:07:00 ZWell, I didn't know which files was "barcode records" and wich one "stockcode". It was just the contrary!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60147/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60147/read.awpHelp with SQL query - HFCSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60145/read.awp27 Oct 2016 22:24:00 ZThanks guys Arie, that was what I tried originally but that returned 16,335 records so I then started playing around with NOT E…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60145/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60145/read.awpHelp with SQL query - HFCSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60136/read.awp27 Oct 2016 09:04:00 ZI think that you don't need a subquery, but to use the "IS NULL" operator. Try this: SELECT * FROM stkmast LEFT OUTER JOIN…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60136/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60136/read.awpHelp with SQL query - HFCSguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60135/read.awp27 Oct 2016 08:39:00 ZHi David, try this syntax. SELECT STKPLU.plu FROM STKPLU WHERE stkplu .sysid NOT IN (SELECT sysid FROM stkmast)https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60135/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/60133-help-with-sql-query-hfcs-60135/read.awpHelp with SQL query - HFCS