I did get the same error, but when I changed the impersonation info to "default" mine worked...

Let's stop confusing the issue and look at the question:

QUESTION:- What will they SQL Statements return?

And considering it doesn't say anything about the SORT ORDER and considering that both...

THE ANSWER TO THIS QUESTION IS CLEARLY WRONG, I DUPLICATED EVERYTHING FROM THE QUESTION EXACTLY AS IT IS IN THE ORIGINAL QUESTION, NO CHANGES!!???!!

select myOrd.Order_No, myiT.Item_No, myOrd.Unique_ID as 'UniqueID'

FROM myOrders myOrd

JOIN...