whats difference between exists and in
Hii experts
Could you tell me where should I opt IN and where to use EXISTS .I've tested it practically ,I dont find any difference among them execpt
the fact that NOT EXISTS will return null ,but NOT IN doesnt.