select a.id, b.name
from 表1 as a
left join 表2 b on a.id = b.id
楼主只是要关联查询即可！
select 表2.name from 表1,表2 where 表1.find=表2.id and 表1.id between 1 and 3
--这是真的表1 id的情况下求表2的值
select b.name from biao1 as a ,biao2 as b where a.find=b.id;
select * from [表1]
findID=find
select * from [表2] where id="findID"
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024