Revision 1e60fc7c
Added by Patrick Plitzner over 7 years ago
| app-import/src/main/java/eu/etaxonomy/cdm/io/redlist/gefaesspflanzen/RedListGefaesspflanzenImportClassification.java | ||
|---|---|---|
| 70 | 70 |
|
| 71 | 71 |
@Override |
| 72 | 72 |
protected String getRecordQuery(RedListGefaesspflanzenImportConfigurator config) {
|
| 73 |
String result = "select e.*, f.FAMILIE " |
|
| 73 |
String result = "select distinct e.*, f.FAMILIE "
|
|
| 74 | 74 |
+ "from V_TAXATLAS_D20_EXPORT e, GATTUNG_FAMILIE f " |
| 75 | 75 |
+ "where e.EPI1 = f.GATTUNG and e.NAMNR IN (@IDSET)"; |
| 76 | 76 |
result = result.replace("@IDSET", IPartitionedIO.ID_LIST_TOKEN);
|
Also available in: Unified diff
#5448 Add "distinct" to SQL query as family table contains duplicate
rows