SELECT
mss.*,
msss.*
FROM
M_SHOP_STAFF mss
INNER JOIN
M_SHOP_STAFF_SHIFT msss
ON
mss.m_s_s_no = msss.m_s_s_no
WHERE
mss.sys_sm_no = ''
AND
msss.sys_sm_no = ''
AND
mss.m_s_s_nonreserve = 0
AND
msss.m_s_s_s_date >= ''
AND
msss.m_s_s_s_date <= ''
AND
msss.m_s_s_s_starttime IS NOT null
AND
msss.m_s_s_s_endtime IS NOT null
AND
msss.m_s_s_s_shiftrelease = 1 ORDER BY msss.m_s_s_s_date ASC, msss.m_s_s_s_starttime ASC