How to find out common records with Where clause
From: Sanjeev <sanjeev.atvankar_at_gmail.com>
Date: Fri, 9 Jan 2009 04:08:03 -0800 (PST)
Message-ID: <fbf05861-6829-4045-855e-56bbfe01d138_at_w24g2000prd.googlegroups.com>
Dear Gurus,
Date: Fri, 9 Jan 2009 04:08:03 -0800 (PST)
Message-ID: <fbf05861-6829-4045-855e-56bbfe01d138_at_w24g2000prd.googlegroups.com>
Dear Gurus,
I have "VISITOR" table as follows.
VisitNo EmpName Address
1 Sanjeev Mumbai 2 Rajeev New-Mumbai 3 Shailesh Mumbai 4 Ramesh New-Mumbai 5 Sanjeev Pune-1 6 Rajeev Pune-2 7 Shailesh Pune-3 8 Shreyas Pune-4 9 Sanjeev Delhi 10 Rajeev New-Delhi 11 Shailesh Delhi 12 Shreyas New-Delhi
If I give location as Mumbai, Pune and Delhi i.e. location based
pattern matching (LIKE operator) then
query should retrieve record as Sanjeev,Rajeev and Shailesh
i.e.
all employees those are present in all given locations (Mumbai, Pune
and Delhi).
query shouldn't retrieve Ramesh, Shreyas because they are not present
in all given location.
I tried with "OR" operator but it did not work.
Could any one help me in above.
Thanking in advance
Sanjeev
Received on Fri Jan 09 2009 - 06:08:03 CST