查询有图片的水库记录：

SELECT *  FROM xxskWHERE (regcode IN   (SELECT regcode  FROM skpic))         

SELECT * FROM xxsk WHERE EXISTS       (SELECT regcode  FROM skpic   WHERE regcode = xxsk.regcode)

 

查询没有图片的水库记录：

SELECT * FROM xxsk WHERE (regcode NOT IN   (SELECT regcode
         FROM skpic))

查询所以水库记录，标明是否有图片：

SELECT skmc, 'pic' = (CASE WHEN regcode IN
          (SELECT regcode
         FROM skpic) THEN '1' ELSE '0' END)
FROM xxsk
 

验证身份，同时统计登陆次数 

string cmdtext = "select zgid,pass,xsq,xiaqu,misrights,logintimes,roleid,";
            cmdtext =cmdtext +" (SELECT COUNT(*) FROM loghistory  WHERE (zgid = @zgid)) AS logtimes"+" from abc where (zgid=@zgid and pass=@pass)";