Newby error in SQL syntax "where" clause

Trumpet · #1 (**permalink**) 02-24-11, 23:24

Hi,

I have the below syntax that is throwing up the following error when I run the query:

Unknown column 'conid' in 'where clause'

Here is the syntax:
-------------------------------------------
SELECT jos_content.id AS conid,
jos_jreviews_content.contentid AS jrconid,
FROM jos_content, jos_jreviews_content
WHERE conid = jrconid
ORDER BY jos_content.id ASC
----------------------------------------------

I am using Navicat to edit and run. Thanks for anyone's help.

r937 · #2 (**permalink**) 02-25-11, 02:58

Code:

SELECT jos_content.id AS conid
     , jos_jreviews_content.contentid AS jrconid 
  FROM jos_content
INNER
  JOIN jos_jreviews_content
    ON jos_jreviews_content.contentid = jos_content.id
ORDER 
    BY jos_content.id ASC

it-iss.com · #3 (**permalink**) 02-25-11, 04:27

Using your own syntax:

Code:

SELECT jos_content.id AS conid,
jos_jreviews_content.contentid AS jrconid,
FROM jos_content, jos_jreviews_content
WHERE conid = jrconid
ORDER BY jos_content.id ASC

The where clause must use the field name and not the renamed field name

Code:

SELECT jos_content.id AS conid,
jos_jreviews_content.contentid AS jrconid,
FROM jos_content, jos_jreviews_content
WHERE jos_content.id = jos_jreviews_content.contentid
ORDER BY jos_content.id ASC