" FROM tblPESIfungi AS distribution RIGHT OUTER JOIN dbo.[tblPESIfungi-IFdata] AS species ON distribution.PreferredNameIFnumber = species.RECORD_NUMBER " +\r
" FROM tblPESIfungi AS distribution RIGHT OUTER JOIN dbo.[tblPESIfungi-IFdata] AS species ON distribution.PreferredNameIFnumber = species.RECORD_NUMBER " +\r
- " WHERE ( species.RECORD_NUMBER IN (" + ID_LIST_TOKEN + ") )" +\r
+ " LEFT OUTER JOIN [tblPESIfungi-Classification] cl ON species.PreferredName = cl.PreferredName " +\r
+ " WHERE ( species.RECORD_NUMBER IN (" + ID_LIST_TOKEN + ") )" +\r
"";\r
return strRecordQuery;\r
}\r
"";\r
return strRecordQuery;\r
}\r
@@ -86,10+91,10 @@ public class IndexFungorumSpeciesImport extends IndexFungorumImportBase {
try {\r
while (rs.next()){\r
\r
try {\r
while (rs.next()){\r
\r
- //TODO\r
- //DisplayName, NomRefCache\r
+ //DisplayName, NomRefCache -> don't use, created by Marc\r
\r
Integer id = (Integer)rs.getObject("RECORD_NUMBER");\r
\r
Integer id = (Integer)rs.getObject("RECORD_NUMBER");\r