Which confirms that you cannot just replace EXISTS with a JOIN

>And?
>
>>With JOIN and DISTINCT also. But you have to add DISTINCT.
>>
>>
>>>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