SQL Server filled out empty rows

In left outer join sample1 is outer table and sample2 is inner table. Outer table is row preserving bringing null from sample2 if no match. In right outer join case is reverse. You can use left outer join, just switch table names. Good luck.