Given following two tables.:
EMPLOYEES:
ID   | NAME       | JOB_ID  |  CURRENT_TASK_ID
--------------------------------------------
01   | Frank      | 01      |  01
02   | Sharon     | 01      |  null
03   | John       | 02      |  02
04   | Jennifer   | 05      |  03
TASKS:
TASK_ID  |  COMMENT
-----------------------
01       |  Project #1
02       |  Project #2
03       |  Project #3
CURRENT_TASK_ID field in EMPLOYEES table is a foreign key referring to TASK_ID field of TASKS table.
How can the following information be extracted:
all available employees and their respective current tasks?

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback
Keep exploring
SQL quizzes
Cosmo
Sign Up Now
or Subscribe for future quizzes