Dear Ron
Try this
===
SELECT `cross_reference_article_2`
FROM `frequently_accessed_passages_of_scripture_cross_reference`
WHERE `cross_reference_article_1` = 1
UNION ALL
SELECT `cross_reference_article_1`
FROM `frequently_accessed_passages_of_scripture_cr
I am trying to setup a cross reference database query for the first time. What
I am trying to do is have a table with the structure:
CREATE TABLE IF NOT EXISTS
`frequently_accessed_passages_of_scripture_cross_reference` (
`reference` int(5) NOT NULL AUTO_INCREMENT,
`cross_reference_artic
Your union creates a table called rss_feed. This table has 4 columns
(page_title, last_update, article and reference) from which you try to
select the unknown column 'title'.
So basicly, exactly what your db is telling you.
If it doesn't make sense, strip the outer select and see what your
subque
I am received the error message:
Unknown column 'title' in 'field list'
from the query below. I am not understanding what I have done wrong. The
goal of the query is with for a RSS feed determining the 15 most current
articles.
Ron
SELECT title, content_date, content, reference FROM ( (
SE
