CGridView + DataProvider

I’m having a problem for a few days and can’t seem to find the right solution.

I would like to display data in a gridview which is coming from two different tables in my database.

Is that possible? I can’t seem to find a good way to do it.

try using CSqlDataProvider and SQL query with UNION. should do the job.