delete fr om 主表 where guid not in (select guid fr om 子表)
delete fr om 子表 where guid not in (select guid fr om 父表)