https://communities.sas.com/t5/SAS-Enterprise-Guide/join-queries/m-p/28524#M3998 Just started using EG (and SAS for that matter) and was wondering if it is possible to create two queries on top of a single table, and then create a query using the results of the first two queries. <BR /> <BR /> I have three columns; one for sales territories, one for product and one dollars. I am trying to group the query so I have a percentage mix product calculated for each territory. I was trying to accomplish this by quering up the sums into two queries, then using a join and expression builder to finish off the math. <BR /> <BR /> Is this possible within a single query? <BR /> <BR /> Thanks for help (using EG 4.1) Mon, 30 Jun 2008 21:49:51 GMT eabegg 2008-06-30T21:49:51Z https://communities.sas.com/t5/SAS-Enterprise-Guide/join-queries/m-p/28524#M3998 Just started using EG (and SAS for that matter) and was wondering if it is possible to create two queries on top of a single table, and then create a query using the results of the first two queries. <BR /> <BR /> I have three columns; one for sales territories, one for product and one dollars. I am trying to group the query so I have a percentage mix product calculated for each territory. I was trying to accomplish this by quering up the sums into two queries, then using a join and expression builder to finish off the math. <BR /> <BR /> Is this possible within a single query? <BR /> <BR /> Thanks for help (using EG 4.1) Mon, 30 Jun 2008 21:49:51 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/join-queries/m-p/28524#M3998 eabegg 2008-06-30T21:49:51Z https://communities.sas.com/t5/SAS-Enterprise-Guide/join-queries/m-p/28525#M3999 Generally, yes. It's called a "correlated subquery". I believe there is an example like that in the SQL chapter in the base manual.<BR /> <BR /> You'll have to do it in a code node; the Query &amp; Report task is not sophisticated enough to do that.<BR /> <BR /> Doc Muhlbaier<BR /> Duke Tue, 01 Jul 2008 01:43:46 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/join-queries/m-p/28525#M3999 Doc_Duke 2008-07-01T01:43:46Z