Help please!!! (1 Viewer)

[Milad]

Hello,
I have a linked table that gives me 10 columns, and I also have another table with the same number of columns. These two tables are having 7 columns the similar but data are different. I have a columns which indicates that from which table the data come from. I am not able to build a query which gives me the data for both table. I am pretty sure that it is either very simple or impossible. I would be thankful if someone could help with this issue.

 

[plog]

Can you post sample data? Include table and field names from both tables, and then what the result should be when this query finishes running. Use this format:

TableNameHere
Field1Name, Field2Name, Field3Name
17, Steve, 12/1/2012
36, Larry, 1/13/2012

 

[Milad]

Thanks for your quick response.
Following is the list of my columns for both tables :
Employee#, WorkDate, CutNum, StyleNum, StyleColor, WorkAllocation
Data For the first table :
712, 8/9/2013, 223344, IT300, Blue, ManualOperator
Data For Second Table :
712, 8/9/2013, 445588, IT500, Yello, ETON
Let me know if you had any other questions.

 

[plog]

2/3 of the way there...

...and then what the result should be when this query finishes running