Question

求一段sql语句：table1中两个字段，id、name。table2中2个字段，id、age。(id内容是一样)

sql查询语句：查询table2中的id显示table1中id相对应的name，和age
查询结果就是三个字段所有的内容在一个表上 id ，name， age，

Answer 1

select t1.name as 姓名,t1.age as 年龄 from table1 as t1 left join table2 as t2 on t2.id=t1.id where t2.id=xxxx

Answer 2

select table2.id,name,age from table1 join table2 on table1.id=table2.id where table2.id=?
问号是要查的table2的Id

Answer 3

select a.name,b.age from table1 a, table2 b where a.id=b.id

Answer 4

select a.id,a.name,b.age from table1 a, table2 b where a.id=b.id