sql语句问题
把下面3条SQL语句合并成一条语句:
select b.reg_num1,b.reg_num2,b.reg_num3
FROM news_relation a,dict_region b
where a.relation_id = b.reg_id and a.news_id = '100000002';

select c.sort_num1,c.sort_num2,c.sort_num3
FROM news_relation a,dict_sort c
where a.relation_id = c.sort_id and a.news_id = '100000002';

select d.menu_num1,d.menu_num2,d.menu_num3
FROM news_relation a,dict_menu d
where a.relation_id = d.menu_id and a.news_id = '100000002';

希望能在一条结果里面查出上面9个字段

[解决办法]
存储过程