Question d’entretien chez Citi

How do you do an inner and outer join in SQL?