Question

sql server 根据外键id查找别的内容

Answer 1

select a.*,b.* from a left join b on a.外键=b。主键

Answer 2

select * from biao1
join biao2
on biao1.id=biao2.id