DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- C# (http://www.daniweb.com/forums/forum61.html)

- - sql (http://www.daniweb.com/forums/thread158912.html)

sivak

Nov 22nd, 2008 6:28 am

sql

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 ...

devanathan_c

Nov 22nd, 2008 8:01 am

Re: sql

Quote:

Originally Posted by sivak (Post 741983)

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;

All times are GMT -4. The time now is 5:10 pm.