The PISDK talks about the ability of GetPointsSQL to generate complex queries
"GetPointsSQL can implement complex queries, including joins with other PI tables."
However, it is not obvious how to define the query. I did not locate a sample that could help/
For example, In PIOleDB, the following could be expressed
.... FROM piarchive.picomp2 a INNER JOIN pipoint.pipoint2 b ON a.tag = b.tag where a.tag='SINUSOID'
How does one do this using GetPointSQL.
Also, can some clarify the usage of nvExtraTableList. As I understand it, this is like a name value pair list.
Samples would be cool.
