I have the code attached and I have two tables with main categories and sub-categories. I'm needing to pull all of the main categories even if there isn't a related ID_KEY in the sub-categories table.
My query now just seems to pull records that only join a sub-category id to main category id
FROM bg_2011_categories t1
LEFT JOIN bg_2011_sub_categories t2
ON t1.id_category = t2.category_id