0

I have a table (employees) like this

ID Name Group Email

1          Bob Buckland       Marketing     b@example.com

2          George Alaz     Engineering   g@example.com

3          Tom Grady       Marketing     t@example.com

4          Mary Jane       Engineering   m@example.com

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

2
Contributors
2
Replies
25
Views
4 Years
Discussion Span
Last Post by riahc3
0

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:
t@example.com

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.