select count(*) from spectree_addrcode_company C, CD, spectree_addrcode_opt CO where 1 and C.CPNO=CO.CPNO and INSTR(C.ADDRGRP,'') > 0 and INSTR(C.ADDRVAL,'') > 0
Table 'nw0023.CD' doesn't exist