🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: ���ű����������

#143
From: ����
Date: Sat, 17 Sep 2011 08:33
22 lines
2201 bytes
create table tempTable as select a.CarResource,b.*,c.* from (tbCar a inner j
oin tbFreeBill b on a.CarCode=b.CarCode) inner join tbFeeBillList c on a.Car
Code=c.CarCode;

join�ܿ�İ����Ҽǵ�֮ǰ���ڵ������Ҳ�������
�� �� merengh (forever_young) �Ĵ������ᵽ: ��
: �ϴ�ѯ�ʵ� ��ʱ�ѹ������� �Ѿ�����ˡ�
: ��������һ�����ű���������⡣
: �շ�վ��һ���������Ƴ�����Ϣ���շ���Ϣ���ϴ�
: ��һ��tbCar����������Ϣ��
: ������ CarCode CarType CarColor �� CarResource�ȼ���������Ϣ �ֶ�
: �����tbFeeBill �շ���Ϣ��
: �������շѵ���Ϣ�ֶΣ�CarCode CarType CarColor ���շ�ʱ�䣬������Ϣ�ֶ�
: ����tbFeeBillList�շ���Ϣ���һ������
: �����������շ���Ϣ�ֶ�CarCode CarType CarColor ���շ�ʱ�䣬�շ��ˣ��շ�վ���ݵ�
: ��Ϣ�ֶ�
: .................������ʡ�ԣ�

--
����Ҫ�����֣�������������

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 111.186.57.82]
Technical Details
Message-ID: <57jeHP$bKb@bbs.sjtu.edu.cn>
Path: arc1-ca.pugleaf.net!m9ni8235pbd.0!nntp.google.com!news1.google.com!goblin2!goblin.stu.neva.ru!feeder.erje.net!texta.sil.at!news.shec6.edu.cn!SJTU

Show Full Headers
Complete Article Headers
X-Google-Thread: 101948,e3c63a4ae194469d,start
X-Google-NewGroupId: yes
X-Google-Attributes: gid4df683fd51,domainid0,public,usenet
X-Google-Language: Chinese,GB
Received: by 10.68.25.8 with SMTP id y8mr319655pbf.16.1316264549309;
        Sat, 17 Sep 2011 06:02:29 -0700 (PDT)
Path: arc1-ca.pugleaf.net!m9ni8235pbd.0!nntp.google.com!news1.google.com!goblin2!goblin.stu.neva.ru!feeder.erje.net!texta.sil.at!news.shec6.edu.cn!SJTU
From: crinto.bbs@bbs.sjtu.edu.cn (����)
Newsgroups: cn.bbs.comp.database
Subject: Re: ���ű����������
Date: 17 Sep 2011 08:33:39 GMT
Organization: ��ˮ˼Դ
Message-ID: <57jeHP$bKb@bbs.sjtu.edu.cn>
Mime-Version: 1.0
X-Filename: database/M.1316248393.A
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit