How do you combine two columns from different tables?
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:
-
Official comment
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
Please sign in to leave a comment.
Comments
3 comments