SQL Join? ***Resolved***

[danielsan]

I have the following problem:

a searchstring seperared by "+" or ",". Something like:

me+you+we

Table:

Index IDCode name
1 1 we
2 1 me
3 2 me
4 2 you
5 2 we
6 3 we
7 3 you

I want to select only the IDCode that has all the names from the string. I have created some code to do this, but it is rather long. Is it possible to create a query who can do this and how?

Thanks for the answer,

danielsan

[si_the_geek]

this should do it:

select * from table
where idcode in (select idcode from table where name = "me")
and idcode in (select idcode from table where name = "you")
and idcode in (select idcode from table where name = "we")

[si_the_geek]

..and if you just want the idcodes change the first line to:
select distinct idcode from table

[danielsan]

sorry, but that didn't work...

[si_the_geek]

it worked for me, did you change the table name/field names to what you have in you database?

what code did you use to run the SQL?

[danielsan]

Sorry, my faliure. The error handler killed the sql-syntax error. I forgot a space somewhere.

Thank you for taking the time to help me.

Regards,

danielsan