[RTJ]

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

[Emile Bons]

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.

[RTJ]

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

Some example?