I hope this finds itself as an answer to my last post. I'm new to this email
message format of lists.
It turns out that the problem with the join was that I had a column being
selected that I removed from my posting example for brevity which was
causing the select to fail. The extra column being selected was:
Adding this to the select meant it returned zero rows. Removing it from the
select made the select work OK.
A bug maybe? The only reason why I can think this particular column might be
causing the problem is that "status" is a keyword of some sort.