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...
Or any examples that could point me in the right direction would be great!