Rename throws SyntaxErrorException

[ghost]

I'm using clojureql 1.0.3 and MySQL database. This code

@(-> (join (table :users) (table :cities)
           (where (= :users.city :cities.id)))
     (rename {:cities.name :city}))

throws following exception:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(*) JOIN cities ON (users.city = cities.id)' at line 1
  [Thrown class com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException]