操作两个表的SQL语句，可用在数据源中

SELECT *,     (SELECT COUNT(*)
         FROM artwork b
         WHERE a.zgid = b.zgid
         GROUP BY b.zgid) AS 作品数,
         

        (SELECT COUNT(*)
         FROM projects c
         WHERE a.zgid = c.zgid
         GROUP BY c.zgid) AS 课题数,
       

        (SELECT COUNT(*)
         FROM paperbook d
         WHERE a.zgid = d.zgid
         GROUP BY d.zgid) AS 论文数

FROM users a where (dept = @dept)">

 

上面的语句操作了四个数据表，用zgid作关联。可以用在sqldatasource里面。绑定到一个GRIDVIEW中。这样在一个GRIDVIEW中就可以显示多个表中的数据了。