关于一句复杂的查询语句,请帮我看看逻辑时候正确

我想让   FURNACEMASTER.FURNACECODE = LINEMASTER.MELTFURNACECODE1 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.MELTFURNACECODE2 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.HOLDFURNACECODE1 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.HOLDFURNACECODE2 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.CASTFURNACECODE为true时候各返回一条结果,也就是说下面的查询语句我认为他最多返回5条数据,最少返回1条数据
返回5条语句的时候
         FURNACEMASTER.FURNACECODE = LINEMASTER.MELTFURNACECODE1 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.MELTFURNACECODE2 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.HOLDFURNACECODE1 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.HOLDFURNACECODE2 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.CASTFURNACECODE的为true,不知道我这么写时候正确SELECT  WORKPROGRESS.a, LINEMASTER.a, FURNACEMASTER.a, CONSTSYSTEMDEFINE.a 
FROM  WORKPROGRESS, LINEMASTER, FURNACEMASTER, CONSTSYSTEMDEFINE
WHERE WORKPROGRESS.LINECODE = LINEMASTER.LINECODE AND 
         WORKPROGRESS.FURNACECODE = FURNACEMASTER.FURNACECODE AND 
         (CONSTSYSTEMDEFINE.KEYTYPE = 'System') AND 
         (CONSTSYSTEMDEFINE.KEYITEM = 'WorkStartTime') AND 
         (FURNACEMASTER.FURNACECODE = LINEMASTER.MELTFURNACECODE1 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.MELTFURNACECODE2 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.HOLDFURNACECODE1 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.HOLDFURNACECODE2 OR
         FURNACEMASTER.FURNACECODE = LINEMASTER.CASTFURNACECODE) AND 
         (LINEMASTER.LINECODE = '001')