Article View: cn.bbs.comp.database
Article #784Re: �ʸ�oracle����Ŀ
From: Galaxy��VOLUNTEERS��Database
Date: Tue, 04 Nov 2008 14:52
Date: Tue, 04 Nov 2008 14:52
22 lines
1347 bytes
1347 bytes
Ҫ��sql server�Ļ�not in��Ч�ʡ���������best practices���Ǿ����ġ����� minus MSSQLû�У�Ʈ��� �� �� Boykins (���-���}�˹����ɽ��ˮ��}������) �Ĵ������ᵽ: �� : 1. : select * from : ( : select * from : math_student a : where a.id not in (select b.id from english_student b) : union : select * from : english_student aa : where aa.id not in (select bb.id from math_student bb) : .................������ʡ�ԣ� -- Welcome to Database Board ��ӭ4����ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;32m�� 4Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.31][m
Technical Details
Message-ID:
<4ci3Yf$aSh@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: �ʸ�oracle����Ŀ Date: 04 Nov 2008 14:52:36 GMT Organization: ��ˮ˼Դ Message-ID: <4ci3Yf$aSh@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1225810313.A Lines: 21