Closed paytonredemer closed 1 year ago
Dev db is updated. Here's an example query using the new schema: SELECT U.* FROM clinical U INNER JOIN mappings P on P.UPN = U.UPN WHERE P.Study_ID = 'tcga_aml' AND (U.FAB='M1' OR U.FAB='M2') ORDER BY U.FAB
SELECT U.* FROM clinical U INNER JOIN mappings P on P.UPN = U.UPN WHERE P.Study_ID = 'tcga_aml' AND (U.FAB='M1' OR U.FAB='M2') ORDER BY U.FAB
generally looks good - one suggestion, and feel free to merge
Dev db is updated. Here's an example query using the new schema:
SELECT U.* FROM clinical U INNER JOIN mappings P on P.UPN = U.UPN WHERE P.Study_ID = 'tcga_aml' AND (U.FAB='M1' OR U.FAB='M2') ORDER BY U.FAB