How to write the SQL for pass-through query?

[jgomez]

I'm not very good with SQL... I'm working on my 1st pass-through query.

I have a table named W_ALS_FLAT & it has a field named BA_CURR_BAL_OR_CM_AMT. I want to pull the loans that have a balance greater than zero...

I have

SELECT MRT_W_ALS_FLAT.BA_CURR_BAL_OR_CM_AMT
FROM MRT_W_ALS_FLAT
WHERE (((MRT_W_ALS_FLAT.BA_CURR_BAL_OR_CM_AMT)>0));

but I get

ODBC--call failed.

[Oracle][ODBC]{Ora]ORA-00942: table or view does not exist (#942)

I know the table exist... I use it. Its just that table has over 500 fields & access limits me to 255??? The only way I know that I can maybe access it is by doing a pass-through query...

[JieJenn]

Ignore my post