I’m trying to query multiple schemas within a single database. Each schema has unique data but the same column names. Am I able to do this and combine the similar columns within Query Builder or do I need to just make different queries for each schema?
For example, I want column A and B from the Colorado schema. Then I want the same columns from the Utah schema, column A and B. Then I want to combine columns that are the same, A columns from CO and UT schemas and B columns from CO and UT.