SQL Problem - Any Suggestions. Thx In Advance.

Hi

Any help with this would be greatly appreciated.

I have two tables

First Table is called "Team" see columns and data below

TeamId, TeamName, MemberId

1, White Team, 1

2, Grey Team, Null

 

Second Table is called "Members" see columns and data below

MemberId, Name

1, Jim Smith

 

I want to display both tables in a gridview as follows

TeamId, TeamName, MemberId, Name

1, White Team, 1, Jim Smith

2, White Team , Null, Null

 

I'm using the following sql procedure to do this

 

Select

Team.TeamId,

Team.TeamName,

Team.MemberId,

Meember.Name

From Team

Inner Join Members on Members.MemberId = Team.MemberId

 

My Problem is that this select statement returns the first row but not the second row. The reason for this is the second row's memberId is Null. However, I still need to display this row even if the data is some of the data is null.

Can anyone point out the correct sql statement for this?