What is the difference between an inner join and outer join in MySQL?Steve Perry
Either I use a LEFT join so as to get the product information, even when there is no image available, but when an image is available, this gives me 7 rows with nulls in the image columns. Or I use an INNER join, which will eliminate the redundant null rows when an image exist, ...