Article View: cn.bbs.comp.database
Article #1387Re: ��һ��sql��ѯ��������
From: ������ݿ�
Date: Wed, 12 Sep 2007 06:15
Date: Wed, 12 Sep 2007 06:15
25 lines
1684 bytes
1684 bytes
����, �ڶ�����ѯ��� �������ظ���! �ij����� select distinct * from a where x union select distinct * from b where y �� �� Huxwell (BlueClub) �Ĵ������ᵽ: �� : �սӴ�sqlû��ã�������Ż�һ����ѯ��䣬�Ұ� : select distinct * from A where X or Y : ��д�� : select distinct * from A where X : union all : select distinct * form A where Y : ֮��Ч������˺ܶ࣬�ұȶ���һ�½����һ�µġ� : ������һ��ͬѧ˵���������������в��ģ������ܻһ������ֲ��ϸ����Ҿ��� : ���������� : ��һʱ��û�����ף�������λ�����ܰ��ҷ���һ��ô�� : .................������ʡ�ԣ� -- [m[1;35m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 222.68.182.226][m
Technical Details
Message-ID:
<4W4La0$cCd@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.szu.edu.cn!bbsnews.sdu.edu.cn!SJTUBBSShow Full Headers
Complete Article Headers
X-Google-Thread: 101948,eb9e2bd010216f98,start X-Google-Attributes: gid101948,public,usenet X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.szu.edu.cn!bbsnews.sdu.edu.cn!SJTUBBS From: alovestory.bbs@bbs.sjtu.edu.cn (������ݿ�) Newsgroups: cn.bbs.comp.database Subject: Re: ��һ��sql��ѯ�������� Date: 12 Sep 2007 06:15:49 GMT Organization: ��ˮ˼Դ Message-ID: <4W4La0$cCd@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1189577664.A