There are whole guidebooks to this, but it's generally pretty annoying. My suggestion? Talk to your DM. For lots of those classes with fixed lists, the core only spells wasn't a balance issue but simply a case of designer laziness or those other spells not being printed at the time - ask if you can swap out spells for thematically similar ones, or simply add some spells from the appropriate schools to your list.