How do the sun, earth, and moon affect each other? ?

So when the Moon rotates around the earth is pulls the water away from the earthcausing high tides. Low tide is caused by the moon and sun working at right angles to each other, their gravitational forces effectively cancel each otherout.