I have two tables from which I need to identifiy unmatched data.
I would simply use an unmatched query except I have mutiple columns that have to be checked.
I thought about doing a large Concatenate and checking that for unmatched but my data also spans rows.
My scenario is thus:
I have Table A that has data for shipping product to a customer. This table is used by shipping department to make shipping arrangments.
I have Table B that has all of the same data but is constantly being updated by the factories. I pull this data once per hour to update the shipping teams data.
I could just update shipping teams data but they have have already begun making arrangements with shipping companies and if anything changed then they have to go back and notify the shipping companies.
The data has mutliple rows because each product on an order gets its own row.
I continue to think that maybe a large concatenate is the answer and I should just write code that would maybe count how many interations of the Order number then move all of them up into one long row that would be concatenated. But not sure how to do that exactly and there possibly is a better way. I a novice coder having to always review my last project to figure out what I am doing wrong so please dumb it down for me some.
I have a sample copy of the pertinent data attached.
thanks...