Having tables with and without prefix in same database

I have tables in my database with prefixes and some without prefixes,

How would I go about using these tables especially in controllers which will take data from 2 or more tables which will have prefixes or without prefixes?

You just use the complete tablename for tables without the prefix or tables with a different prefix… and for table with the prefix you use "{{tablename}}".

Documentation - http://www.yiiframew…fining-ar-class