Oracle数据库多表查询!急!!!在线等!!!
我现在有两张表:
HR_EMPLOYEE(EMPLOYEE_ID,EMPLOYEE_NAME,EMPLOYEE_TYPE_ID,OFFICE_LOCATION_ID)和T_DICT_CATEGORY_VALUE(ID,CODE),HR_EMPLOYEE表中的EMPLOYEE_TYPE_ID和OFFICE_LOCATION_ID都对应T_DICT_CATEGORY_VALUE中的ID,即T_DICT_CATEGORY_VALUE表中的CODE字段既存有EMPLOYEE_TYPE的值也存有OFFICE_LOCATION的值。
比如我现在查找员工姓名和员工类型:
select a.employee_name, b.code employee_type from hr_employee a, t_dict_category_value b where a.employee_type_id=b.id;
那我现在需要在一条SQL中同时将员工姓名、员工类型和所在地(OFFICE_LOCATION)同时查找出来,该怎么写SQL呢?
我是菜鸟,现在项目上遇到这个问题了,很急,希望哪位大大帮小弟解答一下!感激不尽!在线等...
答案:select a.EMPLOYEE_NAME,
EMPLOYEE_TYPE=b.CODE,
OFFICE_LOCATION=c.CODE
from HR_EMPLOYEE a,
T_DICT_CATEGORY_VALUE b,
T_DICT_CATEGORY_VALUE c
where a.EMPLOYEE_TYPE_ID=b.ID
and a.OFFICE_LOCATION_ID=c.ID
其他:表T_DICT_CATEGORY_VALUE(ID,CODE)中的CODE怎么能放两个值呢 select a.employee_name, b.code employee_type,c.code OFFICE_LOCATION
from hr_employee a, t_dict_category_value b,t_dict_category_value c
where a.employee_type_id = b.id
and a.OFFICE_LOCATION_ID=c.id; 试试这样?应该满足你的要求
select a.employee_name,b.code,c.code
from hr_employee a, t_dict_category_value b,t_dict_category_value c
where a.EMPLOYEE_TYPE_ID=b.id and a.OFFICE_LOCATION_ID=c.id
上一个:oracle数据库问题
下一个:系统中不属于关系数据库管理系统是:oracle , ms sql server , ims db2那一个?