Right Outer join

 

--------------------------------------------------------------------------------------

/* The table 1 has 78 rows

   the Business partner table has 45 rows*/

Select * from "<Drop and Drop table 1 from HDI>" as A                                   

Right 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>"

----------------------------------------------------------------------------------------