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



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!