datatable具有其他datatable的所有列. [英] datatable to have all columns of other datatables.

问题描述

我用两个字段和几行填充了两个数据表.

即:
datatable1
ID名称姓氏
1约翰·桑德
2 rob hens
...

datatable2
身份证工作地址
某处有2位老师

问题:
我想最后得到一个数据表，如下所示:
ID名称姓氏职位地址

请问这是怎么做的?
谢谢

I have populated two datatables with several fields and several rows.

i.e.:
datatable1
ID Name lastname
1 john sander
2 rob hens
...

datatable2
ID job address
2 teacher somewhere

Question:
I would like to end up with a datatable as follows:
ID Name LastName Job Address

How is this done please?
Thanks

推荐答案

SELECT datatable1.ID, datatable1.Name, datatable1.LastName, datatable2.Job, datatable2.Address
FROM datatable1
INNER JOIN datatable2
ON datatable1.ID=datatable2.ID

这篇关于datatable具有其他datatable的所有列.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！