Deleting rows in joined tables using ADO

SELECT Elements.*, Groups.GroupName
FROM Elements
INNER JOIN Groups ON Elements.IdGroup = Groups.IdGroup

SELECT Elements.*,
       (
        SELECT Groups.GroupName
          FROM Groups
         WHERE Elements.IdGroup = Groups.IdGroup
       )
  FROM Elements
 WHERE EXISTS (
               SELECT *
                 FROM Groups
                WHERE Elements.IdGroup = Groups.IdGroup
              );