joining two tables

[#1]

Hi everyone,

       could you please help me with this issue.

i have two tables

table1:

ID	A	B
1	20	60
2	30	25
4	10	11

TABLE 2:

ID	A	C
3	33	50
5	30	43
6	21	26

AND I NEED THIS

ID	A	B	C
1	20	60
2	30	25
3	33		50
4	10	11
5	30		43
6	21		26

THANKS!

gerardo

[#2]

Hi

concatenate between two tables

if the field name is same in both the tables

id in both the tables

if ur result is like

t1.id,t2.id  --

for this  use the unqualify

or

use alias to change ur field name to id