I have two tables: Trainings table and Training\_Log table

```
Create Table Trainings
(  Training_ID int
  ,Train_Title varchar(20)
 )

Create Table Training_Log
(   Log_ID int
  , EmployeeName varchar(20)
  , Training_ID int
  , Training_Date date
)
> insert into Trainings values(1,'Sales Training') 
  insert into Trainings values(2,'Risk Management') 
  insert into Trainings values(3,'First Aid')
> 
> insert into  Training_Log values (1, 'Bob Marley', 2, '10/01/2005')
> insert into  Training_Log values (2, 'Bob Marley', 3, '02/05/2006')
> insert into Training_Log values (3,'Ralph Kimball',1,'01/04/2004')

```

How can I write the SQL if I want to get the resultset as follows:

```
   EmployeeName               Train_Title             Train_Date  
   Bob Marley                 Sales Training             Null  
   Bob Marley                 Risk Management           10/01/2005  
   Bob Marley                 First Aid                 02/05/2006
   Ralph Kimball              Sales Training            01/04/2004  
   Ralph Kimball              Risk Management            Null  
   Ralph Kimball              First Aid                  Null

```