Forum Discussion
Solved
Looking for not equal rows
Hello, I have two tables from the same source. The tables consist of machine data, for example there are OrderID's and the Datetime when the machine finished packing it. Unfortunately the leading pr...
Are you using the Composite key to create the relationship? If so, try making it a whole number instead (101052021, 102052021...)
Are you using the Composite key to create the relationship? If so, try making it a whole number instead (101052021, 102052021...)
Very good idea. Thanks PaulDBrown . After replacing all punctuation in the date with space and then combined the column with the order id I got a distinct primary key as a whole number to work with.