>If I have a table that could be tied to a couple other tables, which could have dependents themselves, how could I find records that have no parent/grandparents?

select Child.* from Child LEFT JOIN Parent on Child.FK = Parent.PK where Parent.PK IS NULL

This query works faster than subselect.