Union with unequal number of columns in Laravel

Question

I would like to know how it's possible to make a union/union all query using tables with unequal number of columns (say 3 and 4). I know that I can achieve this using NULL AS col in simple SQL.

However I am working in Laravel and I would like to know whether there is a possible way of doing this using Query/Builder or any other way.

Answer 1

This worked for me, with sql query builder of laravel 5.2

        $first = DB::table('user_prod')
            ->select('user_id', DB::raw("NULL as debit")) //shows 'null' because the 'debit' column does not exist in this table
            ->where('user_id', '=', Auth::user()->id);

        $second = DB::table('user_transaction')
            ->select('user_id', DB::raw("debit")) //shows the value of the column 'debit' table 'user_transaction'
            ->where('user_id', '=', Auth::user()->id)

            ->union($first)
            ->get();

dd($second);