Domanda di colloquio di Retail Insight

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