OPEN Query Linked Server JOIN SQL Server Table

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  December 16, 2011 at 8:40 am

  #248247

  I forgot how to use an OPEN Query Statement and JOIN to a SQL Server Table.

  The SQL Server Table Name is Producer.

  Could someone please provide me with the syntax?

  SELECT *

  FROM OPENQUERY(LSCTLRDAT1, 'SELECT * FROM TBTA11')

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  December 16, 2011 at 10:15 am

  #1422628

  I found what I needed.:satisfied:

  SELECT *

  FROM Company AS co WITH (NOLOCK)

  LEFT JOIN OPENQUERY(LSCTLRDAT1, 'SELECT * FROM PMSPYP00' ) AS DB2

  ON DB2.YP_Account_No = co.AccountNo

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/