🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.bbs.comp.database
Article #852

�ʸ�sql �������

#852
From: ����շ�
Date: Sun, 28 Sep 2008 05:48
13 lines
1509 bytes
���A��B��C���ű���ѡ���
����A������
����B��C�ֱ����ֶ�studyid��subjectid���Ը�A����
��������ʱ��B��C�?һ���м�¼��A��ƥ������
Ҳ����B.studyid=A.studyid��C.subjectid=A.subjectid��һ������
��������ͨ��A��ͬʱouter left join B��C��
��Ҫ�Ľ����A����ֶ�ÿ�ζ�Ҫ��
B��C����ֶ�ֻ����ϵ������ʱ��ȡ�õ�������Ϊ��
��������ǵ���ϵ��������ʱ�����б���ֶζ�Ϊ��
�����sql���Ҫ��ôд��
--

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.1.140.200]
Technical Details
Message-ID: <4cEfgb$b8W@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,98291be71d3ed5c8,start
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU
From: Suppes.bbs@bbs.sjtu.edu.cn (����շ�)
Newsgroups: cn.bbs.comp.database
Subject: �ʸ�sql �������
Date: 28 Sep 2008 05:48:25 GMT
Organization: ��ˮ˼Դ
Message-ID: <4cEfgb$b8W@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1222580485.A
Lines: 12