Article View: cn.bbs.comp.database
Article #10092delphi��SQL�ù�
From: Stray
Date: Tue, 14 Apr 1998 00:00
Date: Tue, 14 Apr 1998 00:00
18 lines
1415 bytes
1415 bytes
ǰЩ����delphi 1.0 д��һ����ݿ����,��һ�����������SQL,����:
select Sale.TicketNo,Sale.oringin,Sale.Type
from Sale,StoredTicketNo
where Sale.TicketNo=StoredTicketNo.TicketNo
����������ݽ���ʱ(100������),û�κ�����,�ɳ���һ������ʱ,
Delphi��Ȼ��TicketNo�ֶ����ΪTicketNo_1,��ʵ�ڲ���Ϊʲô
��¼���ٲ�һ��ʱ,��Query��SQL�õ����ֶ���Ϊ�β�ͬ.(��ʵ��
��ʹ��¼��ʱ,������ͬ�������BDB��SQL�еõ����ֶ���ҲΪTicketNo.)
��Ȼ�������İ취Ҳ�Ǽ�,�ɸ�Ϊ
select Sale.TicketNo TicketNo ,Sale.oringin,Sale.Type
from Sale,StoredTicketNo
where Sale.TicketNo=StoredTicketNo.TicketNo
����ʵ����֪�������ԭ��,����ݿⰮ���߰�æ.
--
�� ��Դ: �й�ƴ�BBSվ [bbs.ustc.edu.cn]
Technical Details
Message-ID:
<980414.yOvgc$PBBS@bbs.ustc.edu.cn>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,b0a6781cad572cb7,start X-Google-Attributes: gid101948,public From: Li_Heng@bbs.ustc.edu.cn (Stray) Subject: delphi��SQL�ù� Date: 1998/04/14 Message-ID: <980414.yOvgc$PBBS@bbs.ustc.edu.cn> X-Deja-AN: 343987226 Organization: �й�ƴ�BBSվ Newsgroups: cn.bbs.comp.database