🚀 go-pugleaf

I am having a silly SQL problem. i know it is probably something
overtly simple.

If you are familiar with SQL could you please advise. Thanks a lot.

Coding in place now:

SELECT sl_subjects.subject_id, sl_subjects.subject_name,
sl_categories.category_name, sl_categories.category_id
        FROM sl_subjects 
        INNER JOIN sl_categories ON sl_subjects.subject_id =
sl_categories.subject_lnk
        ORDER BY sl_subjects.subject_name, sl_categories.category_name


problem:


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

Produces an output error.

Code does work perfectly without the WHERE statement.

Please advise by e-mail: dermegy@home.com