F
fmora
Guest
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...
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...