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?
SQL
SQL Quiz
Start Quiz

or Read more about SQL Quiz

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback