|
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?
|