Revision deafa597
Added by Patrick Plitzner over 7 years ago
src/main/java/eu/etaxonomy/cdm/vaadin/util/CdmQueryFactory.java | ||
---|---|---|
70 | 70 |
} |
71 | 71 |
String FROM_QUERY = |
72 | 72 |
"FROM TaxonNameBase tnb " |
73 |
+ "INNER JOIN TaxonBase tb on tnb.id = tb.name_id and tb.DTYPE='Taxon'" + // # name<->taxon |
|
73 |
+ "INNER JOIN TaxonBase tb on tnb.id = tb.name_id and tb.DTYPE='Taxon' " + // # name<->taxon
|
|
74 | 74 |
"INNER JOIN TaxonNode tn on tn.taxon_id = tb.id "+ |
75 | 75 |
"INNER JOIN DefinedTermBase rank on tnb.rank_id = rank.id "+// # rank <-> name |
76 | 76 |
"LEFT OUTER JOIN DescriptionBase descr on descr.taxon_id = tb.id "+// # taxon <-> taxon description (not every taxon has a description) |
Also available in: Unified diff
ref #5458 add white space to SQL query