Inner joins will select data and return all entries which match
To use a left join or outer join, 1) SELECT * FROM table1 LEFT JOIN table2 ON table2.id=table1.id;
With LEFT JOIN, the first table of the statement is critical. If the first table in the statement has 5 entries, 6 entries would have been selected. But, if tbe first table selected had 6 categories it would show all six entries.