How To Combine Two Queries To The Database?

how to combine two queries to the database?

I need to join these two queries into one:





$a=DB::model()->findAll($criteria);

$b=DB:model()->findAll("a = 0");



php version is 5.2.17

and now need to join in a single queries $c to be sent to pager.

How I can do this?

thank you very much in advance

Read some more about CDbCriteria and you will find out that it’s easy to add ‘a = 0’ to the search criteria as the where clause or by using addColumnCondition.

I need to order the first query and the second query to display the results after the first.

Some example?