Return-Path: 
 <java-user-return-53615-apmail-lucene-java-user-archive=lucene.apache.org@lucene.apache.org>
X-Original-To: apmail-lucene-java-user-archive@www.apache.org
Delivered-To: apmail-lucene-java-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 4C55DD60D
	for <apmail-lucene-java-user-archive@www.apache.org>;
 Mon, 27 Aug 2012 17:06:15 +0000 (UTC)
Received: (qmail 76941 invoked by uid 500); 27 Aug 2012 17:06:13 -0000
Delivered-To: apmail-lucene-java-user-archive@lucene.apache.org
Received: (qmail 76781 invoked by uid 500); 27 Aug 2012 17:06:13 -0000
Mailing-List: contact java-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:java-user-help@lucene.apache.org>
List-Unsubscribe: <mailto:java-user-unsubscribe@lucene.apache.org>
List-Post: <mailto:java-user@lucene.apache.org>
List-Id: <java-user.lucene.apache.org>
Reply-To: java-user@lucene.apache.org
Delivered-To: mailing list java-user@lucene.apache.org
Delivered-To: moderator for java-user@lucene.apache.org
Received: (qmail 93438 invoked by uid 99); 27 Aug 2012 10:02:15 -0000
X-ASF-Spam-Status: No, hits=2.2 required=5.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of truptig@techmahindra.com
 designates 202.67.4.28 as permitted sender)
X-TM-IMSS-Message-ID: <5df01fd300019684@MX7.techmahindra.com>
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01CD843A.F6FE0145"
Subject: Lucene join
Date: Mon, 27 Aug 2012 15:31:45 +0530
Message-ID: 
 <50B2C4C9D727534391DCD15E81D9E9E80B08D3D6@SINMUMEX001.TechMahindra.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Lucene join
Thread-Index: Ac2EOvcU4NXLIfjxSlWwad2R8xI4cg==
From: "Trupti Ghuge" <truptig@TechMahindra.com>
To: <java-user@lucene.apache.org>
X-OriginalArrivalTime: 27 Aug 2012 10:01:45.0838 (UTC)
 FILETIME=[F77768E0:01CD843A]
X-TM-AS-Product-Ver: IMSS-7.1.0.1461-6.8.0.1017-19140.006
X-TM-AS-Result: No--15.881-5.0-31-10
X-imss-scan-details: No--15.881-5.0-31-10
X-TMASE-MatchedRID: vgG0Q5r2caiE6GalAjvSebiMC5wdwKqdETae8Q/uL1H4JyR+b5tvoBa9
	loFFyw8poMd8fz60W5f5boH7tm5XcB2P280ZiGmRJw/R7yVMQfNTXH3GVYWEN45t/XRqktxJ7/+
	9swuISRWd8KCdlHrmBehzKJYil63oW/CDvdPg8vyKC6Im4I1RF/hs+N+bSEhB4pinC0b7AdXwWE
	aNOnlY9/L8w9/9GZdKhW2BDI+9FsyLMWEQIO6h8PilM7nponT86tEkNTIMeQgML9Wb3Qh/hVTNq
	f3EQ8oxyL91Pg+2YRC+VxoTai0ZZ+ioZCwYzzewe5NWR5iixe3/CWEhT9XYVTdHHXXKh5RC3SlE
	gVuyN9tvuYnoduGWEceQPcxT2kjdksrpKXxHf4jQLWxBF9DMQSPzRlrdFGDwePRZdIArrGwnKam
	T8vMZx58ePD+3p/Jcaew7tvWoSAOrhf8eVmUe5w==

------_=_NextPart_001_01CD843A.F6FE0145
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

 

I am new to Lucene. I have a complex query where I need to join more
than two tables and have different filtering criteria on it.

Is it possible to use Lucene for this ?

 

For example , my query is as follows(there is no foreing key relation on
the tables):

 

Select x.id from tablex x, tabley y where (x.id=3Dy.testid and
y.typeid=3D7),.....

 

There are more filter queries ahead.

 

Waiting for your reply.

 

 

Thanks & Regards, 

Trupti Ghuge 

 

 


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3DDisclaimer:  This message and the information contained herei=
n is proprietary and confidential and subject to the Tech Mahindra policy=
 statement, you may review the policy at <a href=3D"http://www.techmahind=
ra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> e=
xternally and <a href=3D"http://tim.techmahindra.com/tim/disclaimer.html"=
>http://tim.techmahindra.com/tim/disclaimer.html</a> internally within Te=
ch Mahindra.=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D

------_=_NextPart_001_01CD843A.F6FE0145--