好康的sql語法

好康的sql語法

SELECT Job_sn,AreaName, B.Member_sn, MotelName, JobName, JobContent, DeadDate
FROM Job J
INNER JOIN BasicInfo B ON J.Member_sn = B.Member_sn
INNER join AreaInfo A on B.AreaCode=A.AreaCode
WHERE JobKind_sn =0 AND Active = 'Y'