从表中检索列 [英] retrieving a column from table

问题描述

嗨frds，



i有两张桌子像;



id table1中的名字年龄





和

id表2中的地址薪水。



现在我想从table1复制age列并将其添加到table2。



提前谢谢....

Hi frds,

i have two table like;

id name age in table1


and
id address salary in table2.

now i want copy the age column from table1 and add it to the table2.

Thanks in advance....

推荐答案

select T2.Id, T2.address, T2.Salary, T1.age
from table1 as T1
inner join from table2 as T2 on T1.Id = T2.Id

这篇关于从表中检索列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！