[Resolved] [Resolved] [Resolved] Order By

[furious5]

I was wondering if anyone can help me.

I am trying to write an SQL query, I want to ORDER all results BY owner where owner = 1, after this I then want to show all results which don't have an owner by ID in ascending order.

Does anyone know the SQL I would use to acheive this??

[tbach2]

order by owner,id

[furious5]

Thank you.