http://www.progenygenetics.com/community/ Progeny Community » Tag: nested query - Recent Topics en Thu, 09 Feb 2012 09:17:53 +0000 http://www.progenygenetics.com/community/topic/51#post-99 Fri, 26 Jun 2009 11:27:53 +0000 tchiang 99@http://www.progenygenetics.com/community/ <p>Hi,</p> <p>I'm trying to figure out if Progeny can handle nested queries in the INDIVIDUAL data spreadsheet. </p> <p>I would like to query for the mother and father ids for a subset of individuals. But because the mother/father ids are system fields that are UPN, I would need to do a sub-nested-query to map the UPNs to their INDIVIDUAL Names. Since this is two queries, how can I achieve this in Progeny where one is the sub of the other.</p> <p>In SQL, I would use two SELECT statements; one as a subquery of the other. Can this be accomplished in Progeny?</p> <p>Thanks,</p> <p>Ted </p>