Forum Discussion
Merge 3 tables by different keys, append same columns
Hello, i basically have one base table consisting of two columns: Date and ranking. I now want to merge two other tables into this. Both tables contain the same column (working hours, cost ce...
Hi Bsngr ,
I don't think 'day of week' fields suitable to use as relationship column, it obviously will existed duplicate values so you can only get summary result when you use key column to get related records.
I'd like to suggest add a unique key column to help relationship mapping more accurate.
Regards,
Xiaoxin Sheng