Select * From doc,doc_assign Where assignDoc = docID and assignResource = 'aim' and docSub = 'tutorial' and docStatus = 1 order by docTop desc,docTitle Resource - Videos - Training - support.gale