在另一个查询中查询加入两个表

Question

我有2个表mstEmp和每日出勤。现在我想运行一个查询

SELECT 
    mstEmp.empname, 
    dailyattendance.InTime, 
    dailyattendance.OutTime, 
    mstEmp.teamtype 
FROM 
    dailyattendance , 
    mstEmp mstEmp 
where 
    dailyattendance.HolderName IN (
    select mstEmp.empname from mstEmp where mstEmp.teamtype='$chk') 

这里teamtype匹配和对应的名称是从mstEmp取出，然后用dailyattendance.HolderName匹配的显示结果。

Answer 1

这个怎么样::

SELECT 
    mstEmp.empname, 
    dailyattendance.InTime, 
    dailyattendance.OutTime, 
    mstEmp.teamtype 

    FROM dailyattendance inner join mstEmp on (dailyattendance.HolderName = mstEmp.empname) 

    where mstEmp.teamtype='$chk' 
    group by mstEmp.empname