请教rowNum 和 left join 写一起时出现的问题
1) SELECT
ROWNUM,
XXXXXB.* FROM (
SELECT
F.LNGDeptPLANDETAILID,
F.LNGDeptPLANID, --科室计划ID
ft.isWorkStandard isWorkstd
FROM deptPLANDETAIL F
LEFT JOIN FyitemType ft
ON F.LNGFYITEMTYPEID = ft.lngFyItemTypeId
WHERE F.LNGDeptPLANID =1707 ORDER BY F.LNGROWID
) XXXXXB;
2) SELECT
F.LNGDeptPLANDETAILID,
F.LNGDeptPLANID, --科室计划ID
ft.isWorkStandard isWorkstd
FROM deptPLANDETAIL F
LEFT JOIN FyitemType ft
ON F.LNGFYITEMTYPEID = ft.lngFyItemTypeId
WHERE F.LNGDeptPLANID =1707 ORDER BY F.LNGROWID;
第二句就是把第一句里面的拿出来了 ,但是查询结果 isWorkstd ,上面为0 下面为 1,
1才是正确的,请问为什么
如果把LEFT JOIN 换成 JOIN ,就正确了,查出来都是 1,没明白,请大神解释一下