SQL Select/Join to Linked DB2 tables Questions on SQL Join

[iGuest 3]

SQL Select/Join to Linked DB2 tablesQuestions on SQL Join

Is it possible to do a select/join on a SQL server table & DB2-Linked table? When I try this I receive Msg 4104, Level 16, State 1

Example:

select   t_detail.[field1],  t_detail.[field2],  db2linkname.Db2schema.Db2table.[field1],  db2linkname.Db2schema.Db2table.[field2]FROM t_Detail INNER JOIN db2linkname.Db2schema.Db2table  ON (t_Detail.[field1] = db2linkname.Db2schema.Db2table.[field1]) ;

-question by RMungerKeywords: