Hi all,

I need to join the following two tables A and B, to have table C:

A:

i j k

1 John Red

2 Mike Yellow

3 Ted Orange

B:

x y z

1 2 Toronto

2 3 New York

3 1 Chicago

C:

i j k l m

1 John Red Toronto Chicago

2 Mike Yellow New York Toronto

3 Ted Orange Chicago New York

Can you please help me what would be the SQL code for this?

Thanks