sql

select * from kcb 
left outer join (select bc.mc bcmc,bj.mc bjmc ,bj.bjid from bj,bc where bc.bcid=bj.bcid) bj on kcb.bjid=bj.bjid 
left outer join (select cdid ,mc cdmc,rnrs,cdlbm from cd) cd on kcb.cdid=cd.cdid 
left outer join (select ryid,mc rymc from ry) ry on kcb.fzryid=ry.ryid 
where kcb.fzryid=(select fzryid from kcb where kcbid=16252);