ambiguous date

I use mysql server and I am getting an error that I don't understand.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.12-max-debug]Column: 'submissiondate' in order clause is ambiguous

/search.asp, line 259

I got this error from an sql statement

sql = "Select * From articles INNER JOIN review ON (articles.articleID = review.ArticleID) Where articlehead like '%" & strKeyWord & "%' OR articletopic like '%" & strKeyWord & "%' OR articleintro like '%" & strKeyWord & "%' AND validated = 1 Order By submissiondate;"

submissiondate is a timestamp datatype

What does this mean?


Edited by cuedog