posted 7 years ago
Hi,
how i can select from 3 tables (task, status, employee):
Task fields:
TASK_ID (PK)
TASK_NAME
DESCRIPTION
STATUS_CODE (FK for status table)
START_DATE
END_DATE
TASK_TYPE_CODE (FK)
PRIORITY_CODE(FK)
EMPLOYEE_ID (FK for employee table)
Status fields:
STATUS_CODE (PK)
STATUS_NAME
Employee fields:
EMPLOYEE_ID (PK)
EMPLOYEE_NAME
I want to select task_id, task_name and end_date"from-to" (any date from the calendar) to (any end date) from task table, status_ name from status table and employee_name from employee table
Thank you in advance.