Query problem on table named 'resource'

  • Thread starter Thread starter phoenix_me
  • Start date Start date
P

phoenix_me

I can't execute query which is 100% right. It is accepted in different
programs but not in excel (Microsoft Query)
The Query is:

select * from PUB.Resource

I think that the problem is because table name is Resource, and this
is reserved word either in SQL '92 or Progress Database. Any hint how
to get data from this table? Any special signs as [ ], ( ), " ", ' ', ?
 
I can't execute query which is 100% right. It is accepted in different
programs but not in excel (Microsoft Query)
The Query is:

select * from PUB.Resource

I think that the problem is because table name is Resource, and this
is reserved word either in SQL '92 or Progress Database. Any hint how
to get data from this table? Any special signs as [ ], ( ), " ", ' ', ?
Click to expand...

I found answer myself. It's need to use aliases together with "".
So query should look like:

select * from PUB."Resource" as my_alias
 
Back
Top