I'm not sure.
Need to test them out as I only tested using a single table query. In the case of character field joins, u can have try having set exact off but use the "==" in the sql joins. Haven't tried this though.
Regards
Yau