Stuck on very easy MySQL query

[riahc3]

I have a table (employees) like this

ID Name Group Email

1          Bob Buckland       Marketing     [e-mail]

2          George Alaz     Engineering   [e-mail]

3          Tom Grady       Marketing     [e-mail]

4          Mary Jane       Engineering   [e-mail]

Im going to use this in a email form. First a combobox should load all the groups possible. This means it should load 2 groups, Marketing and Engineering

Groups is easy I believe:

select distinct Group from employees;

After selecting that, I should load all the names that are in that group.

Im not sure how to do names:

select Name from employees where=?

The "where" condition is what Im not sure about.

And after, how do I get the email I selected?

Thanks

[pritaeas]

SELECT name, email FROM employees WHERE group = '<your_selected_group>'

[riahc3]

select distinct Group from employees;

Result:
Marketing*
Engineering

select Name from employees where Group='Marketing'

Result:
Bob Buckland
Tom Grady*

select Email from employees where Group='Marketing' and Name='Tom Grady'

Result:
[e-mail]

OK got it. Sorry, it was a simply query but It wasnt coming to my head.