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
Обратная Связь
Продолжайте изучать
тесты по SQL
Cosmo
Зарегистрируйся сейчас
или Подпишись на будущие тесты