Where Clause in Pass Through Query

[tledwards]

This is my first time useing a pass-through query but this problem does not any since to me. I am attaching to an Oracle database. Here a simplified version of my SQL statement.

SELECT CONTRACTS.ADMIN_BY_CAO
FROM OLAP_OWNER.CONTRACTS
WHERE CONTRACTS.ADMIN_BY_CAO = "YL"

When I run it I get an 'ORA-00904 - invalid column name' error message. If I take out the where clause it runs. Of course I get all the records which I don't want. I have tried other field names in the where clause with the same results.

Thanks for your help.
Terry

 

[TomCologne]

Replacing the " " double quotes with single quotes 'YL' should do it.

You're not alone,

TomCologne

 

[tledwards]

Tom,
You were correct. All the examples and when Access creates SQL have double quotes.

Thanks,
Terry