SQL Progress column not found

I have this query:

SELECT spechist.item,image."image-path",image."image-item",image."image-source"
FROM PUB.spechist left outer join PUB.image on (image."image-item"=spechist.item)
WHERE (spechist."photocard-display"=yes) AND (spechist."rec-type"='I') and (spechist.item='111')


For some reason I get this error when i run the query:

error message

[MERANT][ODBC PROGRESS driver][PROGRESS]Column not found/specified (7520)

When I remove the following from the query it runs fine:

WHERE (spechist."photocard-display"=yes) AND (spechist."rec-type"='I') and (spechist.item='111')


I know for a fact those columns are in the table. What am I doing wrong?

Thanks

Continue reading...