1. 

   tchiang
   

   Member
   Posted Jun 26, 2009 #

   Hi,

   I'm trying to figure out if Progeny can handle nested queries in the INDIVIDUAL data spreadsheet.

   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.

   In SQL, I would use two SELECT statements; one as a subquery of the other. Can this be accomplished in Progeny?

   Thanks,

   Ted
2. 

   Lianne Mink
   

   Progeny Staff
   Posted Jun 26, 2009 #

   Thanks for your post Ted! This is something that we can help you arrange by developing a computed field in the database. Please contact me at support@progenygenetics.com so that we can work out the details.

Reply

You must log in to post.