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