I just finished piping quite a few tanks together. I used a combination of PVC
glues and primers. If you have the time for a full cure I prefer the grey heavy bodied cement. Over the weeks I used four different brands and types. From Weld On, Christy's, Oatey, & another that eludes me right now. Pretty much personal preference and how quickly you need it to set.