Hi,
There are G1, G2, G3 groups in GROUPS TABLE
and P1, P2, P3, P4, P5 properties in PROPERTIES TABLE. Now in GPMAPPING table
G1 has P1, P2, P3 properties
G2 has p1, p2, p3, p4 properties and
G3 has p1, p5 properties
I want the common properties of G1, G2, G3 groups i.e., output as P1.
Thanks in advance
Loading
Shouketh EKPosted Aug 7, 2009, 8:42 AM
Dear friend..
use this query...
SELECT G1.code,G1.Name FROM G1
INTERSECT SELECT G2.code,G2.Name FROM G2
INTERSECT SELECT G3.code,G3.name FROM G3
for feel free contact
[email protected]
thank you.