select x.fi_ksdm,x.fi_kdmc,s.fi_bysjbh from s
join x,j
on x.fi_ksdm=s.fi_ksdm ,s.fi_bysjbh =j.fi_bysjbh
where j.fs_kdmc =10 and s.fi_bysjbh =15
join x,j
on x.fi_ksdm=s.fi_ksdm ,s.fi_bysjbh =j.fi_bysjbh
where j.fs_kdmc =10 and s.fi_bysjbh =15
from 考生考卷实录 s ,考生信息表 x , 考点记录表 j ,
where s.fi_ksdm=x.fi_ksdm and x.fs_kdmc=j.fs_kdmc
and j.fi_kdbh=10 and j.fi_bysjbh=15