[rpunkfu]

Syntax is fine, it's complaining because you didn't include `JoinDate` column in your query.

[mulmen]

This appears to be a syntax error. I get a different error if I add JoinDate to the SELECT clause without adding the other columns it wants.