Ok, here is what I have to the gallery level and it works. It excludes results that have null in the subcat or gallery table.
The problem I am having now is how to incorporate my (images and gallerylink table)
Here is what I have working in a test query right now...
select root.name as root_name
, down1.name as down1_name
, down2.name as down2_name
from category as root
join subcategory as down1
on down1.CategoryID = root.CategoryID
join gallery as down2
on down2.SubCategoryID = down1.SubCategoryID
where down1.CategoryID is not NULL and down2.SubCategoryID is not NULL