Would this be slightly better than using "not in" in terms of performance?

select b.guid

from TableB b

left join TableA a ON a.guid = b.guid

where a.guid is null

Not sure if this helps, but it worked for a quick report.... Shouldn't be too difficult to link it to a database to retrieve what colour should appear for...