Re: Join and Not Equal to results

[Brian LaMaster]

I used the underscore to represent spaces. As you can see, the results are not "inline" with each other from table 1 and table 2.

TABLE 1____________________________________________________________________|TABLE 2____________________________________________________________________

HANDLE__________________________|VARIANT SKU________|VARIANT INVENTORY QTY_|HANDLE__________________________|VARIANT SKU________|VARIANT INVENTORY QTY_|
1-8-knife-convex________________|___________________|______________________|1-8-knife-convex________________|079LECKK___________|_____5________________|
1-8-knife-convex________________|___________________|______________________|1-8-knife-convex________________|079LECKK___________|_____5________________|
1-8-knife-convex________________|____079LECKK_______|_______5______________|1-8-knife-convex________________|___________________|______________________|
1-8-knife-convex________________|____079LECKK_______|_______5______________|1-8-knife-convex________________|___________________|______________________|
1-8-knife-scandi-grind__________|___________________|______________________|1-8-knife-scandi-grind__________|_____CK18SG________|______0_______________|
1-8-knife-scandi-grind__________|_____CK18SG________|_______0______________|1-8-knife-scandi-grind__________|___________________|______________________|

Thanks!

Brian