Joining tables

T.Raj's Avatar, Join Date: Nov 2008
Newbie Member
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?
0
xpi0t0s's Avatar, Join Date: Aug 2004
Mentor
I don't understand the question. What's the relevance of Table D?
What are you trying to do, create a table or run a query? Or both, i.e. are you doing create table d as select...?
If a query, what columns do you want the query to display?
0
T.Raj's Avatar, Join Date: Nov 2008
Newbie Member
Hi,
I'm trying to upload data from an old database to new database and we are using ID's into the main table for some of the standard value like TABLE B and TABLE C which will have some standard values records.
I have copied these old standard tables without ID numbers to new tables with ID numbers. Now i'm trying to copy the main tables where i have these standard values in some of the records instead of the values i want to compare the values and get the ID from TABLE B and TABLE C
0
xpi0t0s's Avatar, Join Date: Aug 2004
Mentor
I still don't clearly understand the basic goal you're trying to achieve. Could you give a couple of example rows for each relevant table, and what data you want to end up where?

Does table D contain the "old" data that tables A-C now contain in the new format (with IDs)?
If not, what tables exist in the old format?