Ciao a tutti.

Ho queste 3 tabelle in un db mysql:

doTable_1
codice:
ID	NAME_1		NAME_2	
1	JACK		PETER
doTable_2
codice:
ID	ID_DOTABLE_1	NAME_1		NAME_2	
1	1		JACK		PETER
doTable_3
codice:
ID	ID_DOTABLE_1	ID_DOTABLE_2	NAME_1		NAME_2		NAME_3
1	1		1		JACK		PETER		SEAN		
2	1		1		JACK		PETER		WILLY
3	1		1		JACK		PETER		RUBY
4	1		1		JACK		PETER		ROBIN

Come scrivo una query unica x avere questo output ?

codice:
1	JACK		
2	PETER
3	SEAN
4	WILLY
5	RUBY
6	ROBIN
Grazie---