#Dr. Spotfire , I'm trying to customize my information link's SQL.How can I execute this in MySQL

I'm a beginner to MySQL. I'm trying to execute this in MySQL. I want to omit all the PARENTIDs where PROPERTYVALUE='NG'.

My Input is like this 

My Output should be like this

I really appreciate your help.Thanks

(2) Answers