select [user].*,[shjia].* from [user] [shjia] order by [user].addtime desc
或者
select [user].*,[shjia].* from [user] [shjia] order by [shjia].addtime desc
或者
select [user].*,[shjia].* from [user] [shjia] order by [user].addtime desc,[shjia].addtime desc