What really causes moiré in cameras?

What really causes moiré in cameras?