https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-and-SQL-and-UNION/m-p/68701#M6851 Is there a reason why the Query Builder (PRCO SQL) in EG does not have the UNION option in the point &amp; click system or is that a feature that SAS is working on for a later version of EG? Thanks Tue, 16 Mar 2010 14:29:32 GMT JohnH 2010-03-16T14:29:32Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-and-SQL-and-UNION/m-p/68701#M6851 Is there a reason why the Query Builder (PRCO SQL) in EG does not have the UNION option in the point &amp; click system or is that a feature that SAS is working on for a later version of EG? Thanks Tue, 16 Mar 2010 14:29:32 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-and-SQL-and-UNION/m-p/68701#M6851 JohnH 2010-03-16T14:29:32Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-and-SQL-and-UNION/m-p/68702#M6852 You can use the OUTER UNION CORR in a point-and-click way via the task Append Data. I think the demand for the set operators from within the query builder hasn't been that high yet, though it's possible they will be included in a future version of EG. Tue, 16 Mar 2010 18:50:32 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-and-SQL-and-UNION/m-p/68702#M6852 RichardH_sas 2010-03-16T18:50:32Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-and-SQL-and-UNION/m-p/68703#M6853 Demand, demand!<BR /> I would like to have ONE wizard for combining tables via SQL - whether this is a JOIN or a UNION - and things like EXIST would be nice as well. Wed, 17 Mar 2010 12:05:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-and-SQL-and-UNION/m-p/68703#M6853 Patrick 2010-03-17T12:05:44Z https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-and-SQL-and-UNION/m-p/68704#M6854 i second the demand. why a separate task for standard SQL functionality? Tue, 05 Oct 2010 18:11:49 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/EG-and-SQL-and-UNION/m-p/68704#M6854 goat 2010-10-05T18:11:49Z