Probably a broken wire in the harness between the body and door.
I bought a new relay so I ruled out the relay BUT when I jumped pin 30 to pin 87 I got power to pin 10 on the window master switch and the windows worked.It's pin 40 of the C2 connector. Did you try jumping 30 to 87? That bypasses the control circuit and would eliminate it as the problem. When you tested for power at the console did you test from pin 10 of the connector to a nearby ground like a seat belt bolt or to it's ground wire? Do you have power at pin 30 of the relay? The pin numbers should be marked on the relay.