时代

 -- 查找意向单价项目

SELECT DISTINCT
ScopeGUID
FROM
mybizparamoption
WHERE
ParamName = 's_YxDj';

-- 查询意向单价的配置项

SELECT
m.ParamName,
m.ParamValue,
m.ParamGUID,
m.ScopeGUID,
p.ProjCode,
m.ParamCode,
m.ParentCode,
m.ParamLevel
FROM
mybizparamoption m
LEFT JOIN p_project p ON m.ScopeGUID = p.ProjGUID
WHERE
m.ParamName = 's_YxDj'
AND m.ScopeGUID = ?
OR m.ScopeGUID IS NULL
ORDER BY
m.ScopeGUID,
m.ParamCode;