Look up data with multiple values

[veldetta]

I have 2 tables.  1 table has multiple values in 1 column seperated by a ';' (semi-colon).  I need to match/look up another table that has one of the values.

Table 1:

ID

AAAA;BBBB;CCCC

DDDD

EEEE

FFFF;HHHH

IIII

Table 2:

ID

AAAA

BBBB

CCCC

DDDD

FFFF

GGGG

HHHH

Desired Result:

ID	Match	Matching Field
AAAA	Yes	AAAA;BBBB;CCCC
BBBB	Yes	AAAA;BBBB;CCCC
CCCC	Yes	AAAA;BBBB;CCCC
DDDD	Yes	DDDD
FFFF	Yes	FFFF;HHHH
GGGG	No
HHHH	Yes	FFFF;HHHH

How would i go about getting the desired result?

[veldetta]

Thank you all for your responses.