Yes. something similar to :
<dataConfig> <dataSource ***/> <document> <entity name="sample1" transformer="TemplateTransformer" pk="userID" query="select * from USER, CUSTOMER where USER.userID = CUSTOMER.userID"> <field column="rowtype" template="sample1" /> <field column="userID" name="userID" /> <entity name="sample11" transformer="TemplateTransformer" pk="userID" query="select * from CUSTOMER"> <field column="rowtype" template="sample11" /> <field column="custName" name="custName" /> </entity> </entity> <entity name="sample2" transformer="TemplateTransformer" pk="userID" query="select * from USER , MANAGER where USER.desig = MANAGER.desig"> <field column="rowtype" template="sample2" /> <field column="userID" name="userID" /> <entity name="sample22" transformer="TemplateTransformer" pk="userID" query="select * from MANAGER"> <field column="rowtype" template="sample22" /> <field column="custName" name="custName" /> </entity> </entity> </document> </dataConfig> But the searching will not give all the results even if there is only one result. whereas indexing is fine. Thanks con Noble Paul നോബിള് नोब्ळ् wrote: > > do you have 2 queries in 2 different entities? > > > On Thu, Oct 16, 2008 at 3:17 PM, con <[EMAIL PROTECTED]> wrote: >> >> I have two queries in my data-config.xml which takes values from multiple >> tables, like: >> select * from EMPLOYEE, CUSTOMER where EMPLOYEE.prod_id= >> CUSTOMER.prod_id. >> >> When i do a full-import it is indexing all the rows as expected. >> >> But when i search it with a *:* , it is not displaying all the values. >> Do I need any extra configurations? >> >> Thanks >> con >> -- >> View this message in context: >> http://www.nabble.com/Solr-search-not-displaying-all-the-indexed-values.-tp20010401p20010401.html >> Sent from the Solr - User mailing list archive at Nabble.com. >> >> > > > > -- > --Noble Paul > > -- View this message in context: http://www.nabble.com/Solr-search-not-displaying-all-the-indexed-values.-tp20010401p20011033.html Sent from the Solr - User mailing list archive at Nabble.com.