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