Openquery and where clause
Posted on 2003-11-03
Would like help to query a view for data using openquery on a machine running Win2k server and SQL server 2000. The remote machine is running Oracle 816.
My general download query works:
select * from openquery(LinkServer, 'select * from tbl_name')
Would like to add a where clause-> where col_name like "2003%" but erroring out with doesn't recognize column. Have tried various combinations of naming but to no avail.
Schema -> Enterprise
table owner for remote db -> unknown
userid for remotedb -> user_id
table name -> tbl_name
column name -> col_name