双表联合查询

SELECT users.name, users.dept, users.zgid, DERIVEDTBL.ppmc
FROM users LEFT OUTER JOIN
      paperbook DERIVEDTBL ON users.zgid = DERIVEDTBL.zgid
ORDER BY users.zgid

 

 

 

 

该语句是将USERS表中用户的基本信息和PAPERBOOK表中的成果记录根据关键字zgid合并形成新的查询。

 

又如：

SELECT a.ppmc, b.name AS b, a.zgid
FROM paperbook a INNER JOIN
      users b ON a.zgid = b.zgid
WHERE (b.zgid = '0669')

 

DELETE FROM xxsk
WHERE (regcode NOT IN
          (SELECT regcode
         FROM all2)) AND (skgm = '小二型')

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

INSERT INTO xxsk
      (xsq, regcode, skmc, dbzx, zbbx, zdbg, zkr)
SELECT xsq, regcode, skmc, dbzx, zbbx, zdbg, zkr
FROM all2
WHERE (regcode NOT IN
          (SELECT regcode
         FROM xxsk))