Hello there,

sorry about the Title of this post... I can't really figure out how to name this ^^

I'm struggeling with a query that I need to write that does the following:

I have 2 tables:

tblRun
=======================================
TOPIC_ID | RUN_ID | MAIN_CHAR_ID | ALT_CHAR_ID
=======================================
and

tblChar
==========================
char_id | char_name | char_class
==========================

The values in tblRun should be:
=======================================
TOPIC_ID | RUN_ID | MAIN_CHAR_ID | ALT_CHAR_ID
=======================================
123|1|99|555?44?333|

where Alt char ID is separated by the questionmark (these are multiple values)

and in the tblChar there sould be:
==========================
char_ID | char_name | char_class
==========================
99 | Fimlore | 2 |
333 | FimsAlt | 3
555 | FimsOtherAlt | 1

Now, I need a query in which I can add a name to the MAIN_CHAR_ID, as well as to >> all << the ALT_CHAR_ID's
thus, generating something like:

123 | 1 | 99 | Fimlore | 2
123 | 1 | 333 | FimsAlt | 3
123 | 1 | 555 | FimsOtherAlt | 1

is there any way to do this? or should I run a Query for each ? in the ALT_CHAR_ID field?

thanks in advance,

Fimlore