SQL

Article View: cn.bbs.comp.database

Article #9849

Back to cn.bbs.comp.database Previous Next

#9849

From: ��ţ��
Date: Tue, 11 Aug 1998 00:00

12 lines
1264 bytes

                SELECT DISTINCT;
                        &pjyb_file..dwmc,&pjyb_file..jx,&pjyb_file..gg,&pjyb_file..rq,;
                        &pjyb_file..jsl,&pjyb_file..xsl,&pjyb_file..csl,&pjyb_file..bz;
                        FROM &jyb_file;
                        WHERE !DELETED() .AND. LEN(ALLTRIM(&pjyb_file..jx))<>0 .AND. ;
                        &pjyb_file..dwmc NOT IN ;
                        (SELECT &pfile_1..dwmc FROM &file_1 WHERE !DELETED() .AND. ;
                        LEN(ALLTRIM(&pfile_1..jx))<>0) ;
                        ORDER BY &pjyb_file..gg INTO ARRAY _tmphz

--
[m[1;34m�� ��Դ:������������BBS bbs.huizhou.gd.cn��[FROM: 202.96.142.116][m

Technical Details

Message-ID: <3Q3WS0$Wqx@bbs.hz.gnet.gd.cn>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 101948,59ca972891927e6f,start
X-Google-Attributes: gid101948,public
From: bulleye.bbs@bbs.hz.gnet.gd.cn (��ţ��)
Subject: SQL
Date: 1998/08/11
Message-ID: <3Q3WS0$Wqx@bbs.hz.gnet.gd.cn>
X-Deja-AN: 380026202
X-Filename: Database/M.902837568.A
X-Complaints-To: usenet@news.nease.net
X-Trace: news.nease.net 902837968 18870 202.96.142.60 (11 Aug 1998 12:19:28 GMT)
Organization: HuiZhou BBS
NNTP-Posting-Date: 11 Aug 1998 12:19:28 GMT
Newsgroups: cn.bbs.comp.database