T_SQL语句
szzwl 2008-07-25 12:29:54 请教大家一下,查询语句中 内联语句中INNER JOIN..on..可以两个连起来使用吗?
比方说:
SELECT z_Department.Dept_Name,z_DepartmentDecision.DD_IsConfirm,z_DepartmentDecision.Dept_ID,
z_DepartmentDecision.DD_AddDate, z_DepartmentDecision.DD_Content, z_DepartmentDecision.DD_Title, z_Person.Person_RealName, z_DepartmentDecision.DD_ID
FROM z_Department INNER JOIN z_DepartmentDecision ON z_Department.Dept_ID = z_DepartmentDecision.Dept_ID
INNER JOIN z_Person ON z_DepartmentDecision.DD_AddPersonID = z_Person.Person_ID WHERE z_DepartmentDecision.DD_ID ='2'
如果可以的话,后面那个怎么理解?起到什么作用呢
嘿嘿,新手,分不多,暂时只能用20了