Breaking News: Grepper is joining You.com. Read the official announcement!

php Yii2 union query

Luciano I. answered on November 30, 2022 Popularity 3/10 Helpfulness 2/10

answer php Yii2 union query

php Yii2 union query

Comment

//UNION removes duplicate records (where all columns in the results are the same), UNION ALL does not.
        //public $this union ( $sql, $all = false )
        //$all = TRUE if using UNION ALL and FALSE if using UNION
        $query_union = $query_trasferimento
                ->union($query_cashdump, true)
                ->union($query_ticket, true)
                ->union($query_pos, true)
                ->union($query_spesa, true);
 
        //wrap in a subquery and pass the union query in the from param
        $movimenti = (new Query())
                ->select('*')
                ->from(['a' => $query_union])
                ->orderBy(['sort_id' => SORT_ASC, 'operazione' => SORT_ASC])
                ->all();

Popularity 3/10 Helpfulness 2/10 Language php

Source: Grepper

Tags: php union yii2

Link to this answer
Share Copy Link

Contributed on Nov 30 2022

Luciano I.

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

php Yii2 union query

Contents

More Related Answers

php Yii2 union query

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.