Question

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

sql查询语句：查询table2中的id，显示table1中id相对应的内容

Answer 1

select t1.name from table2 t2 left join table1 t1 on t2.id=t1.id where t2.id=你的输入

Answer 2

select * from table1 as t1 left join table2 as t2 on t2.id=t1.id where t2.id=XXX