多个表单,使用where条件连接查询,容易混乱出错。
// An highlighted block
SELECT
a.*,
t.type_name typeName,
u.username userName,
d.dept_name deptName,
sd.VALUE documentsName
FROM
assets_apply a
LEFT JOIN asset_types t ON a.type_id = t.Id
LEFT JOIN sys_user u on a.user_id = u.user_id
LEFT JOIN sys_dept d ON d.dept_id = a.dept_id
LEFT JOIN sys_dict sd ON sd.CODE = a.documents_state
WHERE
a.dept_id = 1;