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");