ÈçÏÂÓï¾ä 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學習~~~ 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
ÓòéѯÓï¾ä select * from tab where fil like 'CK090902'ÄܲéÕÒ³öÒ»Ìõ¼Ç¼²¢ÏÔʾ³öÀ´ ¸ÄΪ select * from tab where fil = 'CK090902' ¾Í²»ÄܲéÕÒµ½£¬Ò²ÏÔʾ²»³öÀ´ ......