Hi,
I have 3 tables
Table A
Emp_Name
Emp_ID
Task_Type

Table B
Task_Id
Task_Type

Table C
TaskDescription_Id
TaskDescription
Task_Id


Instead of values for Task_Type and TaskDescription i want to have their ID in Table D with Emp_Name, Emp_ID, Task_Id, TaskDescription_Id

I tried inner , left outer join but but it does not give me the correct value

SQL statement is

Select A.Emp_Name, A.Emp_ID, B.Tak_Id, C.TaskDescirption_Id from Table A
left outer join Table B on A.Task_Type = B.Task_Type
left outer join Table C on B.Task_Id = B. Task_Id

What am'i doing wrong?