OPENQUERY

• psconsulting

  SSC Eights!

  Points: 944

  More actions

  March 4, 2003 at 10:42 am

  #106194

  How do I use a WHERE clause in an OPENQUERY statment. For example (select * from openquery(server,'select col1,count(*) from test..test_table where col1 = 'I' group by carriermemid'))

  The extra quotes around the I seems to be failing it. How do you specify something in this clause to do that? I tried double quotes but than it treated it as a column

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  March 4, 2003 at 2:36 pm

  #450272

  Try:

  select * from openquery(server,'select col1,count(*) from test..test_table where col1 = ''I'' group by carriermemid')