Yes, it is like the left outer join. In my example.the table may be table or view or stored procedure,I can not change it in database. If for every id in table1,we need search the fields by id from table2 in database,it will met performance issue,especially the size of tables are very big.
-----Original Message----- From: lboutros [mailto:boutr...@gmail.com] Sent: Thursday, April 21, 2011 5:25 PM To: solr-user@lucene.apache.org Subject: RE: The issue of import data from database using Solr DIH What you want to do is something like a left outer join, isn't it ? something like : select table2.OS06Y, f1,f2,f3,f4,f5 from table2 left outer join table1 on table2.OS06Y = table1.OS06Y where ... could you prepare a view in your RDBMS ? That could be another solution ? Ludovic. ----- Jouve France. -- View this message in context: http://lucene.472066.n3.nabble.com/The-issue-of-import-data-from-databas e-using-Solr-DIH-tp2845318p2846403.html Sent from the Solr - User mailing list archive at Nabble.com.