union of fields

[mfaisal.ce]

Hi every one,

is there any way to combine two different from two different tables into one column.....;
example

t1:a1
t2:a2

what i need is,

t3:a1+a2

how i can do that...

 

[isladogs]

Use a query joining t1 & t2 using a suitable field then add a query field

t3:t1.a1+t2.a2

 

[MajP]

You said "combine" and UNION in the title, but you show add. Do you mean add (as in above) or combine/union?
t1
2
4
6

t2
1
3
5

T3
1
2
3
4
5
6

Select a1 from T1 AS A3
Union
Select a2 from T2
ORDER BY 1