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

[saminda roshan]

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

[Shuting Fu]

This might work:

SELECT * FROM MyTable

WHERE MyTable.PARENTIDNOT IN (SELECT PARENTID FROM MyTable WHERE PROPERTYVALUE = 'NG')

[saminda roshan]

Hey Fu

 

Thanks!

 

Ill try it out.