Member Avatar for sheridanbman

I will try to make this as simple as possible. Any help would be greatly
appreciated. I have 3 tables like below.

tblEmployees
-----------------------------------------
EID | Name |
1, John
2, Bob
3, Steve
4, Brian
5, Joel
6, Lance
-----------------------------------------

tblTraining
-----------------------------------------
EID | JOB |
3, 1
4, 1
5, 3
3, 3
4, 2
-----------------------------------------

tblJobFunctions
-----------------------------------------
JID | Job_Name |
1, Picking
2, Packing
3, Shipping
-----------------------------------------

I was looking to produce results like this. Basically it will list ALL employees, and provide me with a scorecard type of training conducted. IS THIS POSSIBLE?

NAME, PICKING, PACKING, SHIPPING
John,No, No, No
Bob,No, No, No
Steve,Yes, No, Yes
Brian,Yes, Yes, No
Joel,No, No, Yes
Lance,No, No, No

  • 2 Contributors
  • 1 Reply
  • 124 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by Ole Raptor
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.