My question is pretty simple, was looking for a simpler answer, Why is C in CAP theorem not same as C in ACID?
Read this HN thread.
Update
A Hitchhiker's Guide to NOSQL v1.0, slide 71 says: C in CAP = A+C (Atomic Consistency)
Both C's stand for consistency, but the notion of consistency in CAP means that "all nodes see the same data at the same time" and the notion of consistency in ACID means that "any transaction the database performs will take it from one consistent state to another". (From Wikipedia.)