Hi,

I'm trying to join 2 tables, looking for example like this :


table 1 (clients : clientid - featureid)

2       6
2       7


table 2 (objects : featureid - objectid)

        6       3
        6       4
        7       3
        6       5
        7       5
        8       5

column 2 for table 1 and column 1 of table 2 match.

Now I only want to show these objects with client 2 that have feature 6 +
7.
So in this case only object 3 (that has 6 + 7) and 5 (that has 6 + 7 + 8)
will be shown.

I am completely in the dark on how to do this, any suggestions?


Thanks !

----------------------------------------------------------------------------------

Marijn Schops
Software Engineer

Professional Interactive Media Centre
Wetenschapspark 5 - 3590 Diepenbeek - Belgium
Tel. +xx-xx-xx xx xx   Fax. +xx-xx-xx xx xx
Email : Marijn.Schops@p...