Difference between revisions of "Talk:Bklein7 Week 14"

From LMU BioDB 2015
Jump to: navigation, search
(added sql query for reference)
 
(made the query able to be copied easily)
Line 1: Line 1:
select propertytype.value from propertytype inner join dbreferencetype on
+
select propertytype.value from propertytype inner join dbreferencetype on
  (propertytype.dbreferencetype_property_hjid = dbreferencetype.hjid)
+
    (propertytype.dbreferencetype_property_hjid = dbreferencetype.hjid)
  where dbreferencetype.type = 'EnsemblBacteria' and propertytype.type = 'gene ID' order by propertytype.value;
+
    where dbreferencetype.type = 'EnsemblBacteria' and propertytype.type = 'gene ID' order by propertytype.value;

Revision as of 23:37, 10 December 2015

select propertytype.value from propertytype inner join dbreferencetype on
   (propertytype.dbreferencetype_property_hjid = dbreferencetype.hjid)
   where dbreferencetype.type = 'EnsemblBacteria' and propertytype.type = 'gene ID' order by propertytype.value;