AnsweredAssumed Answered

PiOLEDB: Query table piarchive.piinterp in combination with join

Question asked by OliverKrieger on Oct 23, 2015
Latest reply on Oct 26, 2015 by HenlodeWaal

Hello,

is it possible to query the piarchive.piinterp table in combination with join?

I want to query a lot of exact times of an pitag by using the sql server.

 

Example:

Select * from [myDB].[dbo].[myTable] as T1

join [PiServer].[piarchive]..[piinterp]  as T2

on T1.pipointname = T2.tag

and T1.timestamp = T2.time

Outcomes