Подскажите!!!

marex 16.03.2003 18:09

делаю пример "Построение деревьев"
и все время получаю ошибку
#------------------------------------------------------------------------------>
Column: 'forum_message_id' in field list is ambiguous

SELECT forum_message_id, parent_id, thread_id, title, author, email, dt_published,
forum_message_body.forum_message_id AS is_not_empty FROM forum_message LEFT JOIN forum_message_body
ON (forum_message.forum_message_id = forum_message_body.forum_message_id)
WHERE 1 = 1 AND parent_id = 0 AND is_published = 1 ORDER BY dt_published

#------------------------------------------------------------------------------>


Уже долго бьюсь, в форуме ничего похожего не нашел... :(
Заранее спасибо

вот сам код
#------------------------------------------------------------------------------>

@getMessagesByParent[parent_id;limit]
$result[^table::sql{
		SELECT
			forum_message_id,
			parent_id,
			thread_id,
			title,
			author,
			email,
			dt_published,
			forum_message_body.forum_message_id AS is_not_empty
		FROM
			forum_message
			^MAIN:pSQL.left_join[from;forum_message_body;forum_message.forum_message_id = forum_message_body.forum_message_id]
		WHERE
			^MAIN:pSQL.left_join[where;forum_message_body;forum_message.forum_message_id = forum_message_body.forum_message_id]
			^if(def $parent_id){parent_id = ^parent_id.int(0) AND}
			is_published = 1
		ORDER BY
			dt_published
}[^if(^limit.int(0)){$.limit(^limit.int(0))}]]

#------------------------------------------------------------------------------>

---