How do you combine two columns from different tables?

Follow

Ben Ohashi

• April 29, 2020 20:50

How do you go about combining columns from different tables? 

 

I have two text columns that I'm looking to combine into one so that I can count the total amount. 

 

When I do a full or inner join, it still has the two columns separate. 

 

Sorry, very novice question!

 

Here's a 1 min video where I explain a little more: 

https://www.loom.com/share/e60eb53fa6404e4d83ecd745ff740186

0

• Official comment

  

  Scott Bowen

  • April 29, 2020 21:06

  Hi Ben!

  You can do that with the MasterSQL report and a Union join— like this:

  SELECT * FROM report1
  UNION ALL
  SELECT * FROM report2;

  Learn more here: https://help.grow.com/hc/en-us/articles/360015197793-Using-the-Master-SQL-Report

  Comment actions Permalink
• 

  Ben Ohashi

  • April 30, 2020 17:02

  Thanks Scott, that worked great!

  0

  Comment actions Permalink
• 

  Scott Bowen

  • April 30, 2020 19:40

  I'm glad it worked out!

  0

  Comment actions Permalink

Please sign in to leave a comment.