Article View: cn.bbs.comp.database
Article #1164��һ��SQL��select ��������
From: �շ�����&���²���
Date: Sun, 16 Mar 2008 07:15
Date: Sun, 16 Mar 2008 07:15
34 lines
1747 bytes
1747 bytes
���õ�����ʦ���runsa(DBA)��� ��Ŀ������ݿ����ſεĿκ���P75 �ĸ��� S�����̣��� P����Ʒ���� J(��Ŀ)�� SPJ ��ϵ������ ����˵�� �������и���ѯ������� select distinct jno from spj where not exists (select * from s where sno = spj.sno and city = '����' ) ������������ʵ��� ��Ҫ���������� ����J1 ֻ�õ��˱������IJ�Ʒ J2 �õ��˱�������IJ�Ʒ J3 J4 J5���õ�������ط��IJ�Ʒ �������ѯû�õ��������IJ�Ʒ����Ŀ��ʱ �������J2 J3 J4 J5 ������ʵ���Ӧ����J3 J4 J5 ������ô����� ���ߵ� лл -- ���û�б��� [m[1;36m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 59.78.24.46][m
Technical Details
Message-ID:
<4Z5c9f$aqX@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,81eefa5a561b4e4e,start X-Google-Attributes: gid101948,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.shec6.edu.cn!SJTU From: bupabupa.bbs@bbs.sjtu.edu.cn (�շ�����&���²���) Newsgroups: cn.bbs.comp.database Subject: ��һ��SQL��select �������� Date: 16 Mar 2008 07:15:36 GMT Organization: ��ˮ˼Դ Message-ID: <4Z5c9f$aqX@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1205651417.A