Hi Zahid, I think the following query will solve your problem. SELECT FID, CNAME FROM ATTENDED WHERE FID IN (SELECT FID FROM ATTENDED HAVING COUNT(FID)=1 GROUP BY FID); Bye....
Forum Rules