Yep, the WD in WD40 stands for "water dispacemnt." It'll work for a short bit, but then the oil part of it (fish oil, I think) breaks down and the squeak returns. I like graphite. It stays in place for a long time and doesn't attract dirt in the joint.
Tom