--------------------------------------------------------------------------------------
/* The table 1 has 78 rows
the Business partner table has 45 rows*/
Select * from "<Drop and Drop table 1 from HDI>" as A
Full outer join "<Drop and drop table 2 from HDI>" as B
On A."<Foreign_key name of table A>" = B. "<Foreign_key name of table B>"
----------------------------------------------------------------------------------------
