Complex Join in Load Script

[Anonymous]

Hello,

I need to perform a join between these two tables:

T_MASTER:

ID_MASTER	DESC_MASTER
IDM01	Master Element 1
IDM02	Master Element 2
....	...

T_DETAIL

ID_DETAIL	DESC_DETAIL	DETAIL_USED_IN
IDD01	Detail Element 1	IDM01 IDM05 IDM10
IDD02	Detail Element 2	IDM02 IDM04

To get this final table:

T_USED_IN:

ID_MASTER	ID_DETAIL
IDD01	IDM01
IDD01	IDM05
IDD01	IDM10
IDD02	IDM02
IDD02	IDM04

Any clue will be appreciated.

Regards,

Javier

[MarcoWedel]

Please mark as answered if there are no further questions.

Thanks

Regards

Marco