WITH句

■WITH句にて、一時テーブルのようなものが作れる。

WITH test AS(
　SELECT * FROM EnumMaster WHERE MasterType = 'Status'
)

SELECT test.mastertext,a.* FROM
agreement AS a
INNER JOIN test ON a.AgmtStatus = test .MasterValue