Re: ��һ��SQL�﷨

Article View: cn.bbs.comp.database

Article #9514

Back to cn.bbs.comp.database Previous Next

#9514

From: û��ʧȥ��Ϊ��û�õ�
Date: Thu, 31 Jul 2003 07:30

23 lines
1478 bytes

select title, name from
(
select title, content from tb1
outer join
select name, content from tb2
)
?


�� �� Pumagh@bbs.pku.edu.cn (One Heart) �Ĵ������ᵽ: ��
: Ҫ��ѯ�����:
: tb1,tb2 �� content����,
: ����ҵ�ƥ��Ľ��, �����:
: �����tb1�е�, ������title����,
: �����tb2�е�, ������name����.
: ���ʲ�ѯ����sql�﷨�������?
: 3Q!


--
��һ�����Ѿ�
ϰ�������ܹ¶�����
[m[1;32m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 218.79.119.241][m

Technical Details

Message-ID: <47TNXL$bqX@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.zixia.net!news.neu.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Language: Chinese,GB
X-Google-Thread: 101948,b40264ec3155d8b6
X-Google-Attributes: gid101948,public
X-Google-ArrivalTime: 2003-07-31 01:22:09 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.zixia.net!news.neu.edu.cn!SJTU
From: wshWaWa.bbs@bbs.sjtu.edu.cn (û��ʧȥ����Ϊ������û�õ�)
Newsgroups: cn.bbs.comp.database
Subject: Re: ��һ��SQL�﷨
Date: 31 Jul 2003 07:30:38 GMT
Organization: ��ˮ˼Դ
Message-ID: <47TNXL$bqX@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1059636549.A
Lines: 23