Sollicitatievraag bij Retail Insight

How SQL joins work. As well as difference between having/where.