You just confirmed that it can be done with LEFT JOIN with DISTINCT.

>
>Ok, There is a parent table and a child table. The child table contains a link to its parent
>
>

>	create cursor parent ;
>	(	p_id		I, ;
>		p_name		c(32) ;
>	)
>	
>	insert into parent  values (1, 'Father Tom')
>	insert into parent  values (2, 'Father Mike')
>	
>	create cursor Child ;
>	(	c_id		I, ;
>		c_p_id		I, ;
>		p_name		c(30) ;
>	)
>	
>	insert into Child values (1, 2, 'Daniel')
>	insert into Child values (2, 2, 'David')
>

>
>I want to find the parents that have children
>
>
>(1) With exists
>

>	select * ;
>		from Parent ;
>		where	( exists ;
>					( select 1 from Child  where c_p_id == p_id ) ;
>				) ;
>		into cursor ParentsWithChildren
>

>
>(2) How would you get the same result with JOIN or LEFT JOIN ? - no fiddling with DISTINCT