athenahealth Interview Question

What is Inner Join and Self Join. Difference between clustered and non-clustered index. Difference between primary key and foreign key.