<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.trs.ggzyexchange.mapper.ZcAlternationeNoticeMapper">

    <select id="queryZcAlternationeNoticeAllList" resultType="com.trs.ggzyexchange.entity.TenderDetailsVo">



        select
            za.SOURCE_DATA_KEY sourceDataKey,
            zp.PROJECT_CODE projectCode,
            zp.PURCHASE_PROJECT_NAME projectName,
            za.PURCHASE_PROJECT_CODE tenderProjectCode,
            za.TERMINATION_BULLETIN_TITLE noticeName,
            za.TERMINATION_BULLETIN_CONTENT noticeContent,
            za.MODIFICATION_START_TIME noticeSendTime,
            zp.REGION_CODE regionCode,
            za.PLATFORM_CODE platformCode,
            za.DATA_SOURCE_CODE dataSourceCode

        from
            zc_alternatione_notice za
                left join ZC_PROJECT zp
                          on za.PURCHASE_PROJECT_CODE = zp.PURCHASE_PROJECT_CODE


    </select>
</mapper>
