Problem with SQL Query

Hi,

I hope someone can help me. Basically I have two tables (with SQL statements below). For each record in tblMember there may be more than one record in tblMemberEducation. I would like to find a way of retrieving details from both tables in one query but only having one row returned for each record in tblMember. At the moment it is not important which related row is returned from tblMemberEducation but it is important that only one row is returned for each row in tblMember.

My query at the moment looks like:
SELECT DISTINCT tblMember.MemberID, tblMember.NameFirst, tblMember.NameSurname, tblMemberEducation.DateTo, tblMemberEducation.CourseCode
FROM tblMember LEFT OUTER JOIN
     tblMemberEducation ON dbo.tblMember.MemberID = dbo.tblMemberEducation.MemberID
WHERE (tblMemberEducation.CourseCode = 'C10059') OR (tblMemberEducation.CourseCode = 'C10060')
GROUP BY tblMember.MemberID, tblMember.NameFirst, tblMember.NameSurname, tblMemberEducation.DateTo, tblMemberEducation.CourseCode

I hope I'm making myself clear.

Thanks (in advance) for your help,
Rei.



---------------------------------------------------------------
CREATE TABLE [tblMember] (
      [MemberID] [bigint] IDENTITY (1, 1) NOT NULL ,
      [NameFirst] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_tblMember_NameFirst] DEFAULT (''),
      [NameSurname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_tblMember_NameSurname] DEFAULT (''),
      CONSTRAINT [PK_tblMember] PRIMARY KEY  CLUSTERED
      (
            [MemberID]
      )  ON [PRIMARY]
) ON [PRIMARY]
GO


CREATE TABLE [tblMemberEducation] (
      [MemberEducationID] [bigint] IDENTITY (1, 1) NOT NULL ,
      [MemberID] [bigint] NOT NULL ,
      [StudentNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
      [CourseCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
      [Version] [smallint] NOT NULL CONSTRAINT [DF_tblCourse_Version] DEFAULT (1),
      [DateFrom] [smalldatetime] NULL ,
      [DateTo] [smalldatetime] NULL ,
      [Completed] [bit] NULL ,
      CONSTRAINT [PK_tblMemberEducation] PRIMARY KEY  CLUSTERED
      (
            [MemberEducationID]
      )  ON [PRIMARY] ,
      CONSTRAINT [FK_tblMemberEducation_tblMember] FOREIGN KEY
      (
            [MemberID]
      ) REFERENCES [tblMember] (
            [MemberID]
      ) ON DELETE CASCADE  ON UPDATE CASCADE
) ON [PRIMARY]
GO