We just upgraded our database from MySQL 4.1 to MySQL 5.0. A query I had that worked in 4.1 does not work now. The message I am getting is :
SQL Error Unknown column 'equipmenttable.equipmenttype' in 'on clause'
The column name that I am having problems with is equipmentType. I refer to it as equipmenttype (small t) instead of the capital T in the table definition.
Anyone know why this would work in one version and not the other? Thanks.
Thank you so much. I rearranged the joins of the query and am no longer getting the error. Thanks for saving me from going down the wrong path on this one.
Here is the query that works :
Anything worth doing well is worth doing poorly first. Just look at this tiny ad:
a bit of art, as a gift, that will fit in a stocking