The problem was widely described in thread over here [topic=‘43218’]Joining Table Created By Select[/topic]
I think it would be nice to implement that join type in Yii, because sometimes it is really needed to do queries like that.
[sql]JOIN ( SELECT * FROM tableName [OTHER STATEMENTS] )[/sql]