Actually folks, don't worry about this one.  I didn't figure out why it was happenning, but I managed to get around it by splitting the complex query up into segments and using temporary tables.