SELECT
K.KOJIN_NO KOJIN_NO,
K.ID_NO ID_NO,
K.NAME NAME,
C.COMPANY_NAME COMPANY_NAME,
S.SECTION_NAME SECTION_NAME,
M.STAFF_KBN_NAME STAFF_KBN_NAME,
K.STATUS STATUS,
K.LIMIT_DATE_TO LIMIT_DATE_TO
FROM
MST_KOJIN K,
MST_COMPANY C,
MST_SECTION S,
MST_STAFF_KBN M
WHERE
K.KOJIN_NO LIKE '%5%'
?? ?? ??? ????.
K.KOJIN_NO LIKE '%5%'? ???? ???? ??? ???? ?????. ?? ?????
??????.
???, ??? ?? ???? ???? ?? MST_CAR ?? ???? ???? ?? ??
???????.
---------------------------------------------------------------------------------------------------------------------------------------------------
SELECT
K.KOJIN_NO KOJIN_NO,
K.ID_NO ID_NO,
K.NAME NAME,
C.COMPANY_NAME COMPANY_NAME,
S.SECTION_NAME SECTION_NAME,
M.STAFF_KBN_NAME STAFF_KBN_NAME,
K.STATUS STATUS,
K.LIMIT_DATE_TO LIMIT_DATE_TO
FROM
MST_KOJIN K,
MST_COMPANY C,
MST_SECTION S,
MST_STAFF_KBN M,
MST_CAR CA
WHERE
K.KOJIN_NO LIKE '%5%
??? ???? ???? ???? ??? ????. ??? ???? ??? ? ?????? ??????,
?? ??? ??... ????. ???? ??? ?? ???? ?? ? ?? ??? ???? ??? ???... ?
??????
????, ???? ?? ???? ??? ?? ???? ??? ??? ??? ?? ????
ps. ?? ???? ??? ???? ????. ?? ????? from ?? MST_CAR? ?? ??? ??
???, ???? ?????.
?? ??? ?? ??, ??????.
???????? ??... ??~~
|