[MS-SQL 쿼리문] INNER JOIN 예제

SELECT a.mNo, a.mCompany, a.authenticationNo, b.bNo,b.bCompany,
              b.bcomNo, b.bjob, b.betc1, b.betc2
FROM    a INNER JOIN
              b on a.mNo = b.bNo
WHERE  (b.bNo = '201008005')