I am having a situation where I need to join 3 tables to pull the required information. Can anyone throw me some ideas!!!
select A.sid, B.cid, C.NAME from table1 A, table2 B, table3 C where A.sid= C.sid and A.oid = B.oid and C.typeid = 5 and C.flag = 0 and B.cid= 1000; Can you please provide schema file above requirement? -- View this message in context: http://lucene.472066.n3.nabble.com/how-to-join-3-tables-to-pull-required-data-tp3985218.html Sent from the Solr - User mailing list archive at Nabble.com.
