Good morning, I have three tables I need to bring together to make one. I am having problems joining two of the tables to get the results I need.
The only way around my problem that I see is to create a seperate table from these and join it to my first table. I have a table that contains departments, plants and department names. Below is an example. The departments for each plant has a different number designation instead of all being consistent. How to I compare the Plant and Number to get the correct name for my query against the Plant and number from my other table? The other table does not have the name just the plant and number. Thanks
Plant Number Name
1234 10 First Assemly
1234 20 Second Assembly
1234 30 Third Assembly
1234 40 Forth Assembly
0987 10 Second Assembly
0987 20 First Assembly
0987 30 Forth Assembly
4567 10 Outer Side
4567 20 Third Assembly
The only way around my problem that I see is to create a seperate table from these and join it to my first table. I have a table that contains departments, plants and department names. Below is an example. The departments for each plant has a different number designation instead of all being consistent. How to I compare the Plant and Number to get the correct name for my query against the Plant and number from my other table? The other table does not have the name just the plant and number. Thanks
Plant Number Name
1234 10 First Assemly
1234 20 Second Assembly
1234 30 Third Assembly
1234 40 Forth Assembly
0987 10 Second Assembly
0987 20 First Assembly
0987 30 Forth Assembly
4567 10 Outer Side
4567 20 Third Assembly
