PVC Primer/Cement

[GQsmooth]

Corix has the same purple/grey.

I saw the clear solvent at HD in the electrical section, but wasn't sure if it was safe for potable water.

[Tyfighter]

Weld on 795 for flex and 705 for rigid are what you want. If it's not the right stuff pool/spa suppliers will have it, I use it all the time.
If you were closer I'd give you some lol. I should say that if anyone in the gvrd needs some send me a pm.