关于拆多表联查的拆分的问题

Question

select c.claimflag ,b.code,c.cname,a.keydat,a.enddat from posdcasinf a,posdchgitm b ,posroprcod c"
+ " where a.orgid =? and a.polnum=? and b.orgid = a.orgid and b.polnum = a.polnum and b.sernum = a.sernum and"
+ " c.orgid = b.orgid and c.operationcode = b.code and c.claimflag='Y'

我现在遇到这个sql，如果我要拆分开这个三表联查，orgid和polnum，sernum，operationcode ，code都是是索引，我应该怎么去实现

Answer 1

直接三表联合就好了，别放在for循环去查。会被骂