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

union 2 table different columns

Add Answer

Karelix Alejandra answered on October 7, 2022 Popularity 9/10 Helpfulness 2/10

Contents

answer union 2 table different columns

More Related Answers

union of two sets python syntax

alter multiple columns in table sql server

sql update multiple columns from another table

sql multiply 2 columns

union vs union all in sql

use the UNION operator to combine the results of multiple SELECT statements into a single result set in sql

oracle sql union tables with different columns

sql update column after sum of 2 columns

take union of two dataframes pandas

how to combine sets using union() function

Which of the following is a UNION query? Select one: a. Combines the output from no more than two queries and must include the same number of columns. b. Combines the output from no more than two queries and does not include the same number of columns. c.

innner join two df on similar columns but different column names

sql union multiple tables

union and union all difference

union and union all

union 2 table different columns

Comment

0

$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();

Popularity 9/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: php union

Share

Link to this answer
Share Copy Link

Karelix Alejandra

Contributed on Oct 07 2022

Karelix Alejandra

0 Answers Avg Quality 2/10

X

Continue with Google

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

X

Grepper Account Login Required

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

Install Grepper Here