Forgot Password,

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

You must login to ask a question.

Need An Account,

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
Leave An Answer!
Home/ Questions/Q 129264
Next
In Process

databaseanswers.net Latest Questions

  • -1
Clara
Beginner
Asked: 2022-05-11T04:43:18-04:00

Join two tables with common column names but no related data

A picture is worth more than a 1000 words, so here it goes. How could I craft a SQL statement to produce the table below?

join SQL problem

In words, two different tables (Incomes and Expenses) share column names, but the row in each table is unrelated. In this case, an income transaction from a given user is unrelated to an expense transaction, even if it is from the same user.

I want to join these two tables into a single table such that all columns from both tables appear, but (1) the common table names are "merged" and (2) the unrelatedness of each row of data is preserved such that the distinct table names from one table are NULL when joined to a row from another table.

joinmergesql

Related Questions

Leave an answer

You must login to add an answer.

Need An Account,

1 Answer

Voted Oldest Recent Random
  1. DhruvJoshi

    I think what you are looking for is UNION query like below

    select userid, username, incomeid, incomeamount, null as ExpenseID, null as expenseAmount
from table1
union
select userid, username, null as incomeid, null as incomeamount, null as ExpenseID, null as expenseAmount
from table2
    • 1