🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: cn.comp.database
Article #66

帮人问个SQL语句

#66
From: DBLobster
Date: Thu, 22 Jun 2006 04:18
32 lines
1626 bytes
����IJ�ѯSQL��ôд!?

�����������?
��Ʒ��Product���ṹ
ProductID
ClassID
ProductName

����Class���ṹ
ClassID
ClassName


Class���Product����һ�Զ��ϵ

����żҪ�õ������ѯ���


ClassName   ProductName
Class_a1   Product_a1, Product_a2
Class_b1   Product_b1
Class_c1   Product_c1, Product_c2, Product_c3
Class_d1

���������SELECT���Ҫ��ôд��

����

http://www.phpx.com/happy/viewthread.php?tid=119286

0316 �ǰ���վ�� http://www.spcmusic.net/
����лл�����
Technical Details
Message-ID: <e7d5na$s4h$1@news.yaako.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.szu.edu.cn!news.cn99.com!news.yaako.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 1106d1,c944b8eba60875d8,start
X-Google-Thread: 107c7f,c944b8eba60875d8,start
X-Google-Attributes: gid1106d1,gid107c7f,public
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!newshub.sdsu.edu!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.szu.edu.cn!news.cn99.com!news.yaako.com!not-for-mail
From: DBLobster <db_lobster@sohu.com>
Newsgroups: cn.comp.database,cn.fan,cn.comp.programm
Subject: 帮人问个SQL语句
Date: Thu, 22 Jun 2006 12:18:56 +0800
Organization: Bentium Ltd. (CN99)
Lines: 32
Message-ID: <e7d5na$s4h$1@news.yaako.com>
NNTP-Posting-Host: 60.0.79.222
Mime-Version: 1.0
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: 8bit
X-Trace: news.yaako.com 1150949931 28817 60.0.79.222 (22 Jun 2006 04:18:51 GMT)
X-Complaints-To: usenet@news.yaako.com
NNTP-Posting-Date: Thu, 22 Jun 2006 04:18:51 +0000 (UTC)
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)