选择JSK."T_CONTRACT" 所有字段,同时选择当T_S_UNCOLLECTED_ANALYZE.CONTRACT_CODE = t_contract.contract_code 时,拿出province_name, city_name 这两个值一起。
请帮我看下怎么写才对?
SELECT *(select province_name, city_name
from T_S_UNCOLLECTED_ANALYZE
where t_contract.contract_code =
T_S_UNCOLLECTED_ANALYZE.CONTRACT_CODE FROM
JSK."T_CONTRACT",