select a,A.offer_code as b,c,B.corp_name as d
from A inner join D on A.corp_id=D.corp_id
inner join B ON D.job_id=B.job_id

------解决方案--------------------
SQL code

--按照楼主的描述。似乎A、B都跟D表有关联。。。那就不需要C表了。如果是的话，可以如下：

select a,b,c,d from A,B,D
where a.corp_id=d.corp_id and D.job_id=B.job_id

------解决方案--------------------
SQL code
select a,A.offer_code as b,c,B.corp_name as d
from A inner join D on A.corp_id=D.corp_id
inner join B ON D.job_id=B.job_id
inner join C ON A.offer_code=C.offer_code 
where c.user_code='XXXXX'

------解决方案--------------------

都是内连接