Problem With WHERE Clause

[eluser]jmadsen[/eluser]
First of all, be clear that there is a difference between helping you to understand a problem and actually doing your work for you. I get paid to do this all week, and I assume you're being paid as well. Dumping a bunch of code & data on a forum and asking someone to figure it out for you is not a habit you want to continue with.

I went ahead and helped you because I can tell it is prolly late Friday night where ever you are and you are stressing out, and I knew it would take me 5 minutes. I was wrong; it took me 2 minutes, and would have taken you the same if you had followed my instructions.

Lecture over. Your problem is none of your data in the sample you gave fits your criteria.

You only have one Princess stone, and its certification type is HRD. The query you posted is "`certification_type` IN ('GIA', 'AGS')"

Hope that was all it is; if not, take your query apart piece by piece and figure out which line is causing the issue.