My city library will pull from nearby libraries for a fee (like $2/work I think?), or I can use my card at those same libraries for free (just need to return to the same library), but AFAIK they don't pull from anything beyond that. We're a relatively small city (like 30-40k people), so maybe things are different downtown.

University libraries, however, will pull from pretty much everywhere, and they have access to a ton of online academic resources.