Difference between revisions of "Talk:Bklein7 Week 14"
From LMU BioDB 2015
								
												
				|  (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) | |
| − | + |     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;

