Miessler and Tarr is an inorganic textbook which is is best suited to an upper-division one-semester inorganic course, though there is more material than can be covered in a single semester, so some choice of topics is necessary.  It is very well suited for a course oriented around structure, bonding, and reaction chemistry of transition metal compounds, but is very limited in its treatment of solids, main-group, descriptive chemistry, and bioinorganic.  Pchem would be helpful but is not necessary.  In particular, the treatment of MO theory is very in-depth.  The quality of end-of chapter p

Housecroft and Sharpe (Inorganic Chemistry, 3ed): This is a comprehensive inorganic textbook designed primarily for students at the Junior/Senior level. P-Chem would not be needed as a prerequisite for this text, but would be helpful. It includes both theoretical and descriptive material along with special topics, enough for a two semester course though it is easily adaptable to a one-semester "advanced inorganic" course by choosing only some topics. It is written in a clear and generally readable style and the full-color graphic contribute to student understanding.