ΪʲôAccess²»Ö§³ÖÄØ£¿

ÈçÏÂÓï¾ä
Select [Name] as sUnit, count(*) as sTime from Cl_BreakRecord inner join Cl_Group On GroupID = Cl_Group.ID and DepartmentID = 3 group by [Name] order by sTime desc

ÔÚsqlÀï²âÊÔʱûÓÐÎÊÌâµÄ
¶øÔÚaccessÀïÃæÈ´Ìáʾ£º²»Ö§³ÖÁ¬½Ó±í´ïʽ¡£
µ½µ×ÊÇÄÄÀïµÄÎÊÌâÄØ£¿
лл£¡

---

access學習~~~

---

ÒýÓÃ

access學習~~~

up

---

SQL code:
--try
Select
[Name] as sUnit, count(*) as sTime
from
Cl_BreakRecord ,Cl_Group
where
GroupID = Cl_Group.ID
and
DepartmentID = 3
group by
[Name]
order by
sTime desc

---

ÄÉÃÆÁË£¬Ã÷Ã÷accessÒ²Ö§³Ö inner join µÄ

---

1.join ²»Ö§³ÖÁÐÃûÓë³£ÊýµÄÁ¬½Ó Ö§³ÖÁÐÃûÓëÁÐÃûµÄÁ¬½Ó
2.ÓÃwhere ¿ÉÒÔʵÏÖ
3.order by ²»ÄÜÓÃÐÂÁбðÃû£¬¿ÉÒÔÓþۺϺ¯Êý»òÁÐ˳ÐòºÅ

---

thanks!

---

Óï·¨²»Ö§³Öѽ