sql

Expand Post »

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

sivak

Reputation Points: 3

Solved Threads: 0

Junior Poster

Offline

132 posts
since Nov 2008

Permalink

Nov 22nd, 2008

Re: sql

Click to Expand / Collapse Quote originally posted by sivak ...

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;

devanathan_c

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Nov 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in C# Forum Timeline: view attachments/html

Next Thread in C# Forum Timeline: Degrees to Radians

DaniWeb Message

Cancel Changes

User Name
Password