G
Guest
Hi
I have 2 tables (a) employee name / ID / work_center and (b) ee_ID /
course_taken / date
I link the 2 with ID and want to generate a query output that will show
training status of any given course such as "list everybody (once only) and
show if he has or has not taken the food poision training?
Employee_table
John 001 kitchen
Tony 002 kitchen
Dave 003 waiter
Mary 004 waiter
Boby 005 boss
course
001 food_poinsion 2004/01/19
001 Org_behavior 2004/03/27
002 Org_behavior 2004/03/27
003 food_poinsion 2004/01/19
004 Org_behavior 2003/09/30
005 Accounting 2004/04/16
desired report:
John food_poision
Tony
Dave food_poision
Mary
Boby
so I can schedule Tony Mary and Boby for training.
Please help to show the blanks.
I don't know anything about SQL or Visual Basic, I am sorry.
I have 2 tables (a) employee name / ID / work_center and (b) ee_ID /
course_taken / date
I link the 2 with ID and want to generate a query output that will show
training status of any given course such as "list everybody (once only) and
show if he has or has not taken the food poision training?
Employee_table
John 001 kitchen
Tony 002 kitchen
Dave 003 waiter
Mary 004 waiter
Boby 005 boss
course
001 food_poinsion 2004/01/19
001 Org_behavior 2004/03/27
002 Org_behavior 2004/03/27
003 food_poinsion 2004/01/19
004 Org_behavior 2003/09/30
005 Accounting 2004/04/16
desired report:
John food_poision
Tony
Dave food_poision
Mary
Boby
so I can schedule Tony Mary and Boby for training.
Please help to show the blanks.
I don't know anything about SQL or Visual Basic, I am sorry.