What type of Joins have you used?

Correct Answer: The knowledge of Joins is a MUST for every interviewee Most SQL programmers have used inner join and outer join[left/right]; but the catch point here is to also mention cross join and self-join