I consider my understanding of MySQL around the intermediate level, but when writing table joins in the past I have always used the ‘equi-join’ method:
SELECT t1.*, t2.`name` FROM t1, t2 WHERE t1.n = t2.n;
Now, when a record for t2.n doesn’t exist, a row will not be returned. To solve this problem in the past, I [...]