Link two tables

[nat35]

Hi there,
I have a field with multiple selection Field(122,3).
How can i link to another table where those numbers are id's
table1 table2
Field1 Field1
122,3 122
3

thank you

 

[philhege]

nat35,

Not sure how this would look (I'm away from the big iron right now), but

select * from table2 where field1 in (select field1 from table1)

The idea being that the parser creates a comma-delimited list of the field contents, so perhaps the commas in the field will mesh with the commas created by the parser.

Failing that, you'd have to do some dynamic SQL to construct the IN clause. It'd be even more of a stretch to do the join in the other direction.

HTH,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....