I have two queries that create two separate tables, pulling on several foreign keys.

Simplified and using retail food as an example, Table 1 looks like this:

Table 2 looks like this:

Essentially, Table 2 contains transactions that do not have a store, and as such are treated differently in our company (and reported on separately). However, I was wondering how can I incorporate both tables to achieve something like this? I am getting stuck since the data pull for each table comes from different places, since in this example, transactions sold without a store get classified completely differently.

Thank you in advance for your help!

CodePudding user response：

In SQL this is called a UNION. You can union two sets if they have the same columns, such as:

select trans_id, city, store, item, description from table1
union
select trans_id, city, 'No Store' as store, item, description from table2