Thursday, July 18, 2013

[SQL Server] Table Join on three columns

[SQL Server] Table Join on three columns


Table Join on three columns

Posted: 17 Jul 2013 05:07 PM PDT

I have two tables with identical structure. one table is for month1 the other is for month2i want to compare the two. the data is issued to us and i am trying to report on the differences. I am trying to compare based on a group of columns Level, code, and area. I cant trust that the groups will be the same in both tables so i'll probably add another table with the unique list of the groupings for each table after wards and use the method to get the Qty from both tables based on the group of columns. i have attached an image to help explain. Thanks

No comments:

Post a Comment

Search This Blog