sql - How to join 2 different table which does not have any link

Question

How to join 2 different table which does not have any link

Table 1 - Stock on hand (has all the item of the store)

Table 2 - Sales

Now I need data from Table 1 and Table 2 in one file Table 1

ItemCode SOH_Quantity
aaaaaaaa 10
bbbbbbbb 12
cccccccc 20

Table 2

ItemCode Quantity InvoiceNo Date
aaaaaaaa 1        001       25/01/2021

I need below output

ItemCode Quantity Type
aaaaaaaa 10        I
bbbbbbbb 12        I 
cccccccc 20        I
aaaaaaaa 1         S

please help me to fetch the expected output

question from:https://stackoverflow.com/questions/65886165/how-to-join-2-different-table-which-does-not-have-any-link

Answer 1

What you described is not a "join", it is a "union".

Use UNION ALL.

SELECT
    ItemCode
    ,SOH_Quantity AS Quantity
    ,'I' AS Type
FROM Table1

UNION ALL

SELECT
    ItemCode
    ,Quantity
    ,'S' AS Type
FROM Table2
;