Joining two different tables

[vvalter]

Hi

 

I need to join two tables with different column names to query result ..

Picture explains ..

 

I have no idea what JOINing to use or what not .. Can you help me to write that query that gives me that result ?

 

 

 

Thanks,

Valter

 

[vvalter]

Cant edit first post?

 

Anyway, the problem is if I join Table A and Table B and i get result like:

 

A_IDA_NAMEA_AGEB_IDB_NAMEB_AGE

1JOHN10NULLNULLNULL

2JAMES30NULLNULLNULL

NULLNULLNULL1JAKE20

NULLNULLNULL2JACK40

 

... but that's not the right result

 

I want result looking more like:

ID

NAME

AGE

1JOHN10

2JAMES30

1JAKE20

2JACK40

[vvalter]

Solution:

 

SELECT a_id id, a_name name, a_age age

FROM table_a

UNION SELECT b_id, b_name, b_age

FROM table_b;