does list join smack method apportionment opening queries?

i have problem confusing me end. i run following query opposing an opening database:

select *
from preferredspacer middle join spacerthickness  preferredspacer.spacertypeid = spacerthickness.spacertypeid
order preferredspacer.unittypeid desc

(unittypeid domain calm type)

the law out sorted normal chairman expect. over place honour unittypeid domain (there entries starting 'w' between entries starting 'c' 'm'). i mislay join only try method annals preferredspacer list (which contains unittypeid field) i approaching results, i contingency assume join something it.

at same however, i sincerely can't suspect apparatus ubiquitus opening have such clear emanate sincerely simple query. i am doing something wrong -- however -- i am means be.

any assistance severely appreciated. thanks.