select
发放人=b.GYName,
领取人=c.GYName,
发放人部门=d.BMName,
领取人部门e.BMName
from
表2 a,表1 b,表1 c,表3 d,表3 e
where
a.FFGYID=b.GYID
and
a.LQGYID=c.GYID
and
b.BMID=d.BMID
and
c.BMID=e.BMID
发放人=b.GYName,
领取人=c.GYName,
发放人部门=d.BMName,
领取人部门e.BMName
from
表2 a,表1 b,表1 c,表3 d,表3 e
where
a.FFGYID=b.GYID
and
a.LQGYID=c.GYID
and
b.BMID=d.BMID
and
c.BMID=e.BMID
libin_ftsafe(子陌红尘|潇湘剑公子@dev-club) 你真好,可以查询出来了