It seems that merge-where only accept the form :table [:= :table.x :table2.y]. Should not be possible to have
(merge-where [:table [:= :table.x :table2.y]])
how do you make a named sub query in honeySQL?
oh nevermind just worked it out