Oracle多张独立的表查询问题
我现在有六张独立的表
A_SYS_COMPANY_BASEINFO,
A_SYS_COMPANY_PRODUCENORM,
A_SYS_COMPANY_CHEMICALNORM,
A_SYS_COMPANY_SELLNORM,
A_SYS_COMPANY_PIPELINENORM,
A_SYS_COMPANY_SERVENORM,
A_SYS_COMPANY_OTHERNORM
SELECT * FROM
A_SYS_COMPANY_BASEINFO,
A_SYS_COMPANY_PRODUCENORM,
A_SYS_COMPANY_CHEMICALNORM,
A_SYS_COMPANY_SELLNORM,
A_SYS_COMPANY_PIPELINENORM,
A_SYS_COMPANY_SERVENORM,
A_SYS_COMPANY_OTHERNORM
where
A_SYS_COMPANY_BASEINFO.Year between 0000 and 1111 and
A_SYS_COMPANY_PRODUCENORM.Year between 0000 and 1111 and
A_SYS_COMPANY_CHEMICALNORM.Year between 0000 and 1111 and
A_SYS_COMPANY_SELLNORM.Year between 0000 and 1111 and
A_SYS_COMPANY_PIPELINENORM.Year between 0000 and 1111 and
A_SYS_COMPANY_SERVENORM.Year between 0000 and 1111 and
A_SYS_COMPANY_OTHERNORM.Year between 0000 and 1111
