mysql子查询 exists,not exists

(1)实现让结果集A-结果集B：--利用not
exists，合并则可用union
exists,not
exists：用于判断且获取结果集A是否存在地结果集B中!
==========结果集A：
SELECT
d.Device_ID,d.Device_Name,a.App_ID,a.App_Name
               from
T_Device_BaseInfo d ,T_App_Spce_R_Info da ,T_App_Info a
              
WHERE d.Spec_Code=da.Spec_Code AND da.App_ID=a.App_ID and 
d.Device_ID=01;
+-----------+-------------+--------+----------------+
|
Device_ID | Device_Name | App_ID | App_Name       |
+-----------+-------------+--------+----------------+
|
01        | coship01    | 01     | maliao         |
| 01        |
coship01    | 02     | maliao         |
| 01        | coship01    |
03     | red alert      |
| 01        | coship01    | 05     |
COD            |
| 01        | coship01    | 08     | flashplayer    |
|
01        | coship01    | 09     | flashplayer6.0 |
+-----------+-------------+--------+----------------+  
6 rows in set (0.00 sec)
==========结果集B：
mysql> select * from T_Device_App_R_Info
where Device_ID=01;
+----+-----------+--------+------+------------+
|
ID | Device_ID | App_ID | Opr  | Setup_Date |
+----+-----------+--------+------+------------+
|
64