针对多字段对单字段查询的解决方案

今天的任务是解决一个查询的问题,

task表中grade和type值对应着business_dict中的id,真实值存储在字典表的name中

如何用一个字段填充查询结果中的两个字段呢?

经过多方查找结论是采用:select ......from t1.*,t1.*.......(select语句)as t1 join (select语句)as t2 on 连接条件

例如:SELECT T1.task_id,T1.task_name,T1.ext1,T1.task_crtdt,T1.task_period,T1.task_pri,
T1.task_grade,T1.task_type,
T1.ext2,T2.ext3
FROM
(SELECT
task_id,task_name,task_crtdt,task_grade,task_type,task_period,task_pri,
project.pro_name AS ext1,
business_dict_name AS ext2
FROM project_task,project,business_dict
WHERE
        project_task.pro_id =project.pro_id
AND project_task.task_grade =business_dict.business_dict_id
AND isuse=1) AS T1

JOIN

(SELECT
task_id,
project.pro_name AS ext1,
business_dict_name AS ext3
FROM project_task,project,business_dict
WHERE
        project_task.pro_id =project.pro_id
AND project_task.task_type =business_dict.business_dict_id
AND isuse=1) AS T2
ON T1.task_id = T2.task_id