Clients not showing up in collection based on query

I have a collection called "Non-Approved Clients" that shows me just that.  I use this to make approving clients easier.
 
Recently I approved 4 laptops named "GD-Cart1-05", "-06", "-09" and "-12".
 
These show up in the collection "All Systems" as assigned to the correct site code with an approved client.
 
The DO NOT show up (even after a collection update and refresh in a collection called "1 - Glendaal".  That collection is based on the following query:
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.Name like "GD-%"
 
Originally the colletion query was not limited.  So I tried limiting it to "All Approved Systems" and "All Systems" in an attempt to solve the issue.  No joy.
 
Any ideas on what is causing this?  I'm also wondering if this is isolated or if I have other collections with the same issue.
 

You are asking for where SMS_G_System_SYSTEM.Name like "GD-%"
not where SMS_R_System.Netbiosname like "GD-%"
What if you stick with the SMS_R_System (the one that comes from heartbeat) not the SMS_G_System (the one that comes after a successful hinv).

I tried both "where SMS_R_System.Name like "GD-%"" and "where SMS_R_System.Netbiosname like "GD-%"".
 
Both gave me an invalid query error on clicking OK.

Sorry, I don't have a console in front of me, I was going by memory.  that said, don't type in exactly what I wrote; in the collection query wizard use the pull downs etc. to select the right attributes for the Where clause.

I find this to be a problem with G_System... use R_System
SMS_R_SYSTEM.Name="XXX" or like "%xyz%"

here is what I have in collection I use to single out some machine by the beginning of their hostname, of course change host to GD:
 
select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.Name like "host%"

In the query designer, select System Resource and Name to get SMS_R_System.Name and make sure the query is not limited.  If the query that the collection is based on is limited to another collection, the computers won't show up until the limiting collection is updated according to its schedule. (or manually)
 

SELECT SMS_R_System.Name FROM SMS_R_System WHERE SMS_R_System.Name LIKE "GD-%"

should work just fine.  Make sure you're using the same names in each of the SELECT, FROM and WHERE statements.