
Òѽâ¾öÎÊÌâ
¹È¸è±»·ç´µ¹ýµÄº£°¶Óû§ÔÚ2014.02.24Ìá½»Á˹ØÓÚ¡°Ãëɱ**¿âÁ¬½ÓÎÊÌ⡱µÄÌáÎÊ£¬»¶Ó´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ5¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2025-02-25T16:25:34¡£**LECTmmliid,max(M.PUdate)asPUdate,max(M.wsc_name)aswsc_name,count(*)ASbookTimesFROMmm_bookdetailDINNERJOINmm_bookmasterM
ONd.MCBKCode=M.MCBKCodegroupbymmliid
mm_bookdetail±íÓÐ849522Ìõ¼Ç¼£¬mm_bookmasterÓÐ79482Ìõ¼Ç¼£¬ÔÚmm_bookdetail±íµÄmmliid½¨Á¢ÁËË÷Òý£¬µ«ÊÇinnerjoinµÄ¿ªÏú»¹ÊǺܴó£¬ÎªÁËÓÅ»¯ÎÒÔÚ¿¼ÂDz»ÓÃÁ¬½Ó£¬µ«ÊDz»ÖªµÀÔõô¸Ã£¬»¹Íû¸÷λ´óÏÀ²»Ï§´Í½Ì£¬Ð»ÁË£¡
ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£º
**LECTmmliid,max(M.PUdate)asPUdate,max(M.wsc_name)aswsc_name,count(*)ASbookTimesFROMmm_bookdetailDINNERJOINmm_bookmasterM
ONd.MCBKCode=M.MCBKCodegroupbymmliid
mm_bookdetail±íÓÐ849522Ìõ¼Ç¼£¬mm_bookmasterÓÐ79482Ìõ¼Ç¼£¬ÔÚmm_bookdetail±íµÄmmliid½¨Á¢ÁËË÷Òý£¬µ«ÊÇinnerjoinµÄ¿ªÏú»¹ÊǺܴó£¬ÎªÁËÓÅ»¯ÎÒÔÚ¿¼ÂDz»ÓÃÁ¬½Ó£¬µ«ÊDz»ÖªµÀÔõô¸Ã£¬»¹Íû¸÷λ´óÏÀ²»Ï§´Í½Ì£¬Ð»ÁË£¡