Suppose that I have an $A$ - module $N$ with $A$ commutative and I take a projective resolution of $N$:
$$\ldots \rightarrow P_2 \rightarrow P_1 \rightarrow P_0 \rightarrow N \rightarrow 0.$$
Suppose $M$ is some other $A$ - module. Now why is it the case that
$$\ldots \rightarrow P_2 \otimes_A M \rightarrow P_1 \otimes_A M \rightarrow P_0 \otimes_A M \rightarrow N \otimes_A M \rightarrow 0 $$
is not exact? I know that the tensor product is not in general left exact. However if the projective resolution is an infinite one then there is no "left" so why should the sequence above not be exact?
There has to be some problem with my understanding for then we always have $\textrm{Tor}_i^A(M,N) = 0$ for all $i$.