Member Avatar for 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 ...

  • 2 Contributors
  • 1 Reply
  • 87 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by devanathan_c
Member Avatar for devanathan_c

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;

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.