Need help with SQL Query syntax?

Other than including info not requested (publisher address and sorting the results), looks fine to me. The methodology you use for giving aliases should work on any DBMS I'm aware of and joining tables implicitly via WHERE is just as good as using an explicit inner join clause.