version conflict...

[The Plankmeister]

Hi again,

This works perfectly in v4, but in v3.23 it throws a syntax error. I can't
see what it is at all... Very frustrating!

SELECT DISTINCT page_system_nam e
FROM page_data JOIN menu_data ON menu_data.menu_ group = page_data.menu_ group
WHERE page_hidden = 0
ORDER BY menu_data.menu_ group_display_o rder, page_data.page_ display_order

Hope someone can help,

Plankmeister.

[The Plankmeister]

Oooops... ignore.

"The Plankmeister" <plankmeister@_ NOSP_AM_hotmail .com> wrote in message
news:yP******** ********@news.g et2net.dk...

Hi again,

This works perfectly in v4, but in v3.23 it throws a syntax error. I can't
see what it is at all... Very frustrating!

SELECT DISTINCT page_system_nam e
FROM page_data JOIN menu_data ON menu_data.menu_ group = page_data.menu_ group WHERE page_hidden = 0
ORDER BY menu_data.menu_ group_display_o rder, page_data.page_ display_order

Hope someone can help,

Plankmeister.

[Bill Karwin]

The Plankmeister wrote:

Hi again,

This works perfectly in v4, but in v3.23 it throws a syntax error. I can't
see what it is at all... Very frustrating!

SELECT DISTINCT page_system_nam e
FROM page_data JOIN menu_data ON menu_data.menu_ group = page_data.menu_ group
WHERE page_hidden = 0
ORDER BY menu_data.menu_ group_display_o rder, page_data.page_ display_order

Guesses:

Try putting the join condition in the WHERE clause. Join conditions in
an ON clause is supported only in version 3.23.17 and higher, according
to http://dev.mysql.com/doc/mysql/en/JOIN.html

Try "INNER JOIN" instead of simply "JOIN". A long shot, I'm sure, but
worth a try.

Regards,
Bill K.