Query Question

[trainsteve]

I have a table that contains the list of people's names and team leaders:
For Example:

Member Name Team Leader
Bob Johnson Sue Hall
Sue Hall Nick Jones
Jack Nichols Sue Hall
Mary Smith Sue Hall

What I need help with is what to i need to put in a query that return all
members of Sue Hall's Team, in which the 3 members (Bob, Jack, Mary) are
returned as well as the team leader Sue

 

[Ofer Cohen]

Something like

Select * From TableName Where [Member Name] = [Please select a name] Or
[Team Leader] =[Please select a name]

The user will be prompt with the message [Please select a name]

 

[KARL DEWEY]

Is this what you are looking for ---
SELECT trainsteve.[Member Name], trainsteve_1.[Team Leader]
FROM trainsteve LEFT JOIN trainsteve AS trainsteve_1 ON trainsteve.[Member
Name] = trainsteve_1.[Team Leader]
GROUP BY trainsteve.[Member Name], trainsteve_1.[Team Leader];