SQLTeam.com | Weblogs | Forums

Query output help

Greetings,

I need help to get all rows from left table and matching records from the right table.

Left table
id value1
Null NIOP
1 Sam
2 Rob
3 Kim
Null Needinoutput

Right table
id value2
1 USA
2 GB
3 Germany
4 Italy

Expected output:

id Value1 Value2


Null NIOP Null
1 Sam USA
2 Rob GB
3 Kim Germany
Null Needinoutput Null

select   
  * 
from 
   getting_all_columns_table 
      left join 
   other_table
       on    getting_all_columns_table.column =     other_table.Column