how do u keep the results after doing a join and getting some records returned. I then need to get a count of all the nulls in a particular column of those records returned. But I can't seem to figure out how to get a count of those null records. The temp table is out of juice at that point?

Help?