Untitled

Same output for two entirely different queries
ab<-sqldf('select a.Family_tree_id, a.parent_name
           from test as a, test as b
           where a.child_id <> b.parent_id
           group by a.Family_tree_id')

cd<-sqldf('select a.Family_tree_id, a.parent_name
           from test as a
           where a.parent_name NOT IN
           (select b.child_name from test as b)')