Article View: bit.listserv.sqlinfo
Article #243Re: Simple SQL question
From: Don Arsenault
Date: Thu, 21 Sep 2000 00:00
Date: Thu, 21 Sep 2000 00:00
21 lines
1124 bytes
1124 bytes
INNER JOIN is part of the FROM clause. Put the WHERE clause after INNER
JOIN.
Don.
Dermegy! wrote in message <07ucss8n31qi0gniia6bb8ghu23rrp2gll@4ax.com>...
:
:
how come I cant ad in WHERE subject_id <> 38 after FROM ...without an
error ?
i.e.
SELECT sl_subjects.subject_id, sl_subjects.subject_name,
sl_categories.category_name, sl_categories.category_id
FROM sl_subjects
WHERE subject_id <> 38
INNER JOIN sl_categories ON sl_subjects.subject_id =
sl_categories.subject_lnk
ORDER BY sl_subjects.subject_name, sl_categories.category_name
Technical Details
Message-ID:
<TVwy5.104$aE21.6291591@news.randori.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<07ucss8n31qi0gniia6bb8ghu23rrp2gll@4ax.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 11355a,c89593fed44645f X-Google-Attributes: gid11355a,public From: "Don Arsenault" <darsenault@hughes.net> Subject: Re: Simple SQL question Date: 2000/09/21 Message-ID: <TVwy5.104$aE21.6291591@news.randori.com> X-Deja-AN: 672657968 References: <07ucss8n31qi0gniia6bb8ghu23rrp2gll@4ax.com> Organization: Randori News Inc. -- http://www.randori.com -- Great Retention! Newsgroups: bit.listserv.sqlinfo X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700