>What's the exact syntax for a SQL to get all the parent which do not have any children?
You mean like:
Select * from parent;
where fieldx not in;
(select fieldx from child)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.