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?

Следи за CodeGalaxy

Мобильное приложение Beta

Get it on Google Play
Обратная Связь
Cosmo
Зарегистрируйся сейчас
или Подпишись на будущие тесты