Uwe,

U> SELECT DISTINCT *
U> FROM Tbl T1 LEFT OUTER JOIN Tbl T2 ON (T1.ID = T2.Link)
U> WHERE T1.Name LIKE 'ZAR%';

U> And it now shows the main record and the child record however it shows the
U> main record for every child record again even with distinct.

thst's because your tuples are not distinct. Try select T1.* and see
if it helps. BTW better yet would be to avoid the * altogether.

Ciao
--
Nando mailto:nandod@...