>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.
If it's not broken, fix it until it is.
My Blog