I want to learn too, but don't want traditional lessons from a teacher - not yet at least. I'd be too embarrassed until I can at least do the basics. I did learn the violin for several years so am OK to some extent with theory.
What book(s) would anyone recommend?
So far, the following have been suggested:
The Classic Piano Course
Alfred's Basic and All in One Adult Piano Course
Thanks in advance.
I now use the Fanny Waterman books, as they were recommended by my teacher. Working through them, with her, teaches me the basics and that's what I need, not to rush ahead, but to learn each bit thoroughly. You shouldn't be worried about going to a teacher with zero knowledge, it will be easier to be taught how to do things "right" from the off, rather than do your own thing, only to have to re-learn them at a later date. For me, that's been essential as I have unruly fingers from 25 years of touch-typing
Any teacher will not care if you know nothing, all you need is to be keen to learn and put in the effort.