jsnider

Having problems with a SQL query agains my AF server...

Discussion created by jsnider on Dec 1, 2011
Latest reply on Dec 2, 2011 by hanyong

Hello,

 

I am having problems developing the proper query to achieve what I'm looking for.

 

Granted: I am not great with SQL, and I have looked throu all the examples provided with PI SQL Commander.

 

What I am looking for the query to return is the element name, description, and snapshot value for element attribute "A" where Element attrubute "B" is a specified value... (Hope that makes sense). It seems that this should be not too complicated, but I can't seem to come up with a good query...

 

Any thoughts?

 

Or any examples that could point me in the right direction would be great!

Outcomes