Interview Question

Anonymous Interview Cork (Ireland)

Name the types of

joins used in sql and what each one does

Interview Answer

1 Answer


left inner join - all rows on left hand table are read and only those rows that match on the right hand side,
 left outer join - reverse of left,
self join - use alias's to join tables

Interview Candidate on Oct 21, 2009

Add Answers or Comments

To comment on this question, Sign In with Facebook or Sign Up