i have table A with coloum f1 and table B with coloum f2...want to combine these to 2 coloums and make coloums f3(f3=f1+f2)
can anyone tell me the query for that ...

Hi
use this query,

Select concat(T1.fname, T2.lname) as name from tab1 as T1
join tab2 T2 on T1.id=T2.id;