I am going to have to disagree with your assessment this it worked the way you wanted it to. Yes, it may look like it returned the results you wanted, but it's just by luck.

You have non-unique ID numbers, and you asked to retrieve regardless of datetime, therefore you have no basis for selecting any order.
Additionally, I don't see how you can have a constraint for primary key on a column that doesn't even exist in your table.

>The query retrieves the correct results that I was looking for.
SQL will ALWAYS return rows or report "No Rows Found".
HOWEVER the rows returned may not actually be the ones desired under all conditions depending upon what actually exist within the tables when the SELECT is issued.