pcsoft.us.windevCopyright 2026, PC SOFT22 Jul 2015 14:26:00 Z22 Jul 2015 00:23:00 ZHi all - I'm not very good at SQL, so rather than spend hours trying to figure this one out on my own, I figured I'd ask for help first. I have 2 files, both have a ContactID field in them. I want to create a single list of ContactID's - without any duplicates in them. So basically if a contact shows up in either of these files, I want to work with them. Any have some code to get me started? I don't know anything about inner / outer joins (other than they exist)30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53186/read.awp22 Jul 2015 14:26:00 ZThanks guys!https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53186/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53186/read.awpWEBDEV19 - How to Code SQL, 2 files, only bring back Uniqueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53179/read.awp22 Jul 2015 11:11:00 ZHi Joel, No the ContactID wouldn't show up twice. This is the difference between UNION and UNION ALL. UNION - removes dupl…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53179/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53179/read.awpWEBDEV19 - How to Code SQL, 2 files, only bring back Uniqueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53177/read.awp22 Jul 2015 02:59:00 ZBut if the same ContactID is in both files, after you do the union, wouldn't it show up twice in the final file?https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53177/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53177/read.awpWEBDEV19 - How to Code SQL, 2 files, only bring back Uniqueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53176/read.awp22 Jul 2015 02:26:00 ZI'd suggest a slight change... SELECT DISTINCT table1.customerID from table1 UNION SELECT DISTINCT table2.customerID from t…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53176/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53176/read.awpWEBDEV19 - How to Code SQL, 2 files, only bring back Uniqueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53175/read.awp22 Jul 2015 01:17:00 ZCorrection: Select table1.customerID from table1 UNION Select table2.customerID from table2https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53175/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53175/read.awpWEBDEV19 - How to Code SQL, 2 files, only bring back Uniqueguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53174/read.awp22 Jul 2015 01:16:00 ZOut of the mind and not tested: Select table1.customerID UNION Select table2.customerID should do a distinct select S…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53174/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/53172-webdev19-how-code-sql-2-files-only-bring-53174/read.awpWEBDEV19 - How to Code SQL, 2 files, only bring back Unique