Author:
pcskySQL statement as follows: SELECT DD.SumHits, AA.CountArt, CC.WeekUpdate, BB.RegUserNumFROM (SELECT COUNT (newsid) AS CountArt FROM article) AA, (SELECT COUNT (id) AS RegUserNum FROM Admin) BB, (SELECT COUNT ( NEWSID) AS WeekUpdate from (Article) Where Datediff ('ww', DateandTime, Now ()> = 7) CC, (Select Sum (Hits) AS Sumhits from Article DD Run Environment: vs.net 2003 with OLEDBConnection controls Used a child, because it is not convenient to write separately.
