Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --before
- SELECT WorkCode.WORK_CODE_ID,
- WorkCode.VEHICLE_OWNER_ID,
- WorkCode.WORK_CODE_NAME,
- WorkCode.SHORT_CODE,
- WorkCode.LM_COMMENT,
- WorkCode.WORK_CODE_STD_ID,
- WorkCode.ORDER_NUM,
- WorkCode.MOBILITY_IS_PAID
- FROM WORK_CODE WorkCode
- WHERE VEHICLE_OWNER_ID = ?
- ORDER BY ORDER_NUM ASC
- --after
- SELECT WorkCode.WORK_CODE_ID,
- WorkCode.VEHICLE_OWNER_ID,
- WorkCode.WORK_CODE_NAME,
- WorkCode.SHORT_CODE,
- WorkCode.LM_COMMENT,
- WorkCode.WORK_CODE_STD_ID,
- WorkCode.ORDER_NUM,
- WorkCode.MOBILITY_IS_PAID
- FROM WORK_CODE WorkCode, GUI_USERS GuiUsers, STR Str
- WHERE WorkCode.STR_ID = Str.STR_ID(+)
- AND GuiUsers.LANGUAGE = Str.STR_ID(+)
- AND GuiUsers.GUI_USER_ID = ?
- AND WorkCode.VEHICLE_OWNER_ID = ?
- ORDER BY ORDER_NUM ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement