read the f*cking source code

SELECT
	*
FROM
	(
		SELECT
			ID = row_number () OVER (
				partition BY SUPPLIERNAME
				ORDER BY
					AUDITDATE
			),
			t.*
		FROM
			(
				SELECT
					gys.SUPPLIERNAME,dd.poid,
					dd.AUDITDATE,
					ht.salesman
				FROM
					IV_T_SUPPLIER gys,
					sm_t_spc ht,
					SM_T_SP_DETAIL mx,
					SM_T_POC dd
				WHERE
					gys.SUPPLIERID = ht.supplierid
				AND ht.soid = mx.soid
				AND mx.POID = dd.POID
				AND dd.AUDITDATE > ''
				UNION
					SELECT
						gys.SUPPLIERNAME,dd.poid,
						dd.AUDITDATE,
						ht.salesman
					FROM
						PDERP.dbo.IV_T_SUPPLIER gys,
						PDERP.dbo.sm_t_spc ht,
						PDERP.dbo.SM_T_SP_DETAIL mx,
						PDERP.dbo.SM_T_POC dd
					WHERE
						gys.SUPPLIERID = ht.supplierid
					AND ht.soid = mx.soid
					AND mx.POID = dd.POID
					AND dd.AUDITDATE > ''
			) t
		WHERE
			t.auditdate > '2016-03-15'
		AND t.auditdate <= '2016-06-15'
		AND t.SUPPLIERNAME NOT IN (
			SELECT
				tt.SUPPLIERNAME
			FROM
				(
					SELECT
						gys.SUPPLIERNAME,
						dd.AUDITDATE
					FROM
						IV_T_SUPPLIER gys,
						sm_t_spc ht,
						SM_T_SP_DETAIL mx,
						SM_T_POC dd
					WHERE
						gys.SUPPLIERID = ht.supplierid
					AND ht.soid = mx.soid
					AND mx.POID = dd.POID
					UNION
						SELECT
							gys.SUPPLIERNAME,
							dd.AUDITDATE
						FROM
							PDERP.dbo.IV_T_SUPPLIER gys,
							PDERP.dbo.sm_t_spc ht,
							PDERP.dbo.SM_T_SP_DETAIL mx,
							PDERP.dbo.SM_T_POC dd
						WHERE
							gys.SUPPLIERID = ht.supplierid
						AND ht.soid = mx.soid
						AND mx.POID = dd.POID
				) tt
			WHERE
				tt.auditdate <= '2016-03-15'
		)
	) t2
WHERE
	t2.ID = 1
ORDER BY
	suppliername