ROWNUM,
XXXXXB. * FROM (
SELECT
F.L NGDeptPLANDETAILID,
F.L NGDeptPLANID - plan ID department
Ft. IsWorkStandard isWorkstd
The FROM deptPLANDETAIL F
LEFT the JOIN FyitemType ft
ON F.L NGFYITEMTYPEID=ft. LngFyItemTypeId
WHERE F.L NGDeptPLANID=1707 ORDER BY F.L NGROWID
) XXXXXB;
2) SELECT
F.L NGDeptPLANDETAILID,
F.L NGDeptPLANID - plan ID department
Ft. IsWorkStandard isWorkstd
The FROM deptPLANDETAIL F
LEFT the JOIN FyitemType ft
ON F.L NGFYITEMTYPEID=ft. LngFyItemTypeId
WHERE F.L NGDeptPLANID=1707 ORDER BY F.L NGROWID;
The second sentence is to bring out the inside of the first sentence, but the query results isWorkstd, under the above 0 to 1,
1 is correct, could you tell me why
If change LEFT the JOIN to JOIN, just right, found out are 1, didn't understand, please explain the great spirit
CodePudding user response:
Nothing left the join is left to the right is only the left, the join is the internal connection, both sides meet the join condition is the result
CodePudding user response: