Need to join 2 tables and keep all the columns from both the tables as output. The outer join need to happen

[Arpit_Jhamb]

So i have 2 tables - Input1 and input2 as follows –>
Input1 is feeding into a loop and creating input 2. once the input2 is completed, i wan tot join input1 and input2 whihc i trying to via merge.

The issue is that when i am joining it, 2 issues are happening –> 1. the data is not joining 2. I am not getting all the columns from both the tables

Attaching both tables and the merge output below below
input1 –>

Input2 –>

merge –>

I ahve tried everything. Even changing the table names and colukmns properly but nothing seems to work.

[krisn0x]

Hey there!

Can you try renaming the columns and use this updated syntax?

SELECT 
  input1.column1,
  input1.column2,
  input2.*
FROM input1
LEFT JOIN input2
  ON input1.column1 = input2.column2;