Sorry, I was mistaken about it not working on 5.4, however, you need to set the error reporting level to not display Deprecated messages or Strict errors.
Contact the host for details on editing the error reporting level in the php.ini file.
The Query Builder can help quite a bit with creating complex join queries.