Complete Joy of Homebrewing is my favorite and the book that got me started in homebrewing about 22 years ago. However, once you get past the basic and intermediate levels, you'd probably be better off with something that incorporates more modern techniques. Not saying Charlie's are bad, but he doesn't cover BIAB or batch sparging, and to me he makes all-grain seem more complicated than it has to be. Still, it's a classic and has a laid-back, witty attitude that's very infectious. Highly recommended.
Other than that, you can't go wrong with Palmer's book, plus an older edition is available for free online. Dave Miller's "Brew Like a Pro" is a good one. "Homebrewing for Dummies" by Marty Nachel is actually pretty good too. "The Brewer's Apprentice" by Greg Koch of Stone is a fun read. Ray Daniels' "Designing Great Beers"...I could go on and on. (I like to read homebrewing books, as you might have guessed.)