github.com/Bio-core/jtree@v0.0.0-20190705165106-1d7a7e7d6272/sql/select_joins.sql (about) 1 Select COLUMN_NAME FROM 2 ( 3 SELECT "samples" as TABLE_ONE,TABLE_NAME as TABLE_TWO ,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = 'JTree' AND REFERENCED_TABLE_NAME = 'samples' 4 UNION 5 SELECT "patients" as TABLE_ONE,TABLE_NAME as TABLE_TWO ,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = 'JTree' AND REFERENCED_TABLE_NAME = 'patients' 6 UNION 7 SELECT "experiments" as TABLE_ONE,TABLE_NAME as TABLE_TWO ,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = 'JTree' AND REFERENCED_TABLE_NAME = 'experiments' 8 UNION 9 SELECT "results" as TABLE_ONE,TABLE_NAME as TABLE_TWO ,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = 'JTree' AND REFERENCED_TABLE_NAME = 'results' 10 UNION 11 SELECT "resultdetails" as TABLE_ONE,TABLE_NAME as TABLE_TWO ,COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = 'JTree' AND REFERENCED_TABLE_NAME = 'resultdetails' 12 ) a 13 WHERE (TABLE_ONE = "samples" && TABLE_TWO = "experiments") || (TABLE_ONE = "experiments" && TABLE_TWO = "samples");