From 0f9e3501be54e951c9101d448e8003ad693f6834 Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Tue, 6 Jun 2023 14:45:16 +0300 Subject: Add missing Species join when dumping datasets Signed-off-by: Munyoki Kilyungi --- examples/dump-dataset-metadata.scm | 1 + 1 file changed, 1 insertion(+) (limited to 'examples/dump-dataset-metadata.scm') diff --git a/examples/dump-dataset-metadata.scm b/examples/dump-dataset-metadata.scm index bdf8a7d..7519582 100755 --- a/examples/dump-dataset-metadata.scm +++ b/examples/dump-dataset-metadata.scm @@ -85,6 +85,7 @@ (left-join GenoFreeze "ON InfoFiles.InfoPageName = GenoFreeze.Name") (left-join ProbeSetFreeze "ON InfoFiles.InfoPageName = ProbeSetFreeze.Name") (left-join InbredSet "ON InfoFiles.InbredSetId = InbredSet.InbredSetId") + (left-join Species "ON InfoFiles.SpeciesId = Species.SpeciesId") (left-join Datasets "USING (DatasetId)") (left-join DatasetStatus "USING (DatasetStatusId)") (left-join Tissue "USING (TissueId)") -- cgit v1.2.3