inner join 抓到重複資料

摘要:inner join 抓到重複資料

 

SELECT     dwMaster.askNo
FROM         dwMaster INNER JOIN
                      Employee ON dwMaster.askNo = Employee.工號

 Employee.工號沒設master key

有重複data