l*r
2 楼
Not sure.
hehe
DELETE a FROM TABLE_1 WHERE NOT EXISTS
(SELECT * FROM TABLE_2 WHERE c=b)
【在 M******t 的大作中提到】
: DELETE a FROM TABLE_1 WHERE b NOT IN (SELECT c FROM TABLE_2)
: 怎么能改写成不用IN啊？
hehe
DELETE a FROM TABLE_1 WHERE NOT EXISTS
(SELECT * FROM TABLE_2 WHERE c=b)
【在 M******t 的大作中提到】
: DELETE a FROM TABLE_1 WHERE b NOT IN (SELECT c FROM TABLE_2)
: 怎么能改写成不用IN啊？
相关阅读
a problemHelp!!!oracle connection problemODBC help!2000下连接mysql的问题网页中数据库格式显示问题from where can i get the acamedic info on Databas如何安装Oracle内置包DUMMY question: Intro to SQL.[转载] jdbc的问题~{8_JVGsVz~}: how to create trigger on a nested table?Mysql limitsdatabase evaluationHow to know which database I am connected?Re: How to create a MS Access Database File using DAO in vc++???Re: How to concatenate NULL value with a string in SQL Server?help!How to create a MS Access Database File using DAO in vc++???ORA0-01422nt下的oracle