dokuwiki

insert into accountants (first_name, last_name, salary, email, hire_date, job_id) 
SELECT   employees.first_name, employees.last_name, employees.salary, ' ', sysdate,  ' '
   FROM jobs, employees
   WHERE (    (jobs.job_id = employees.job_id)
          AND (jobs.job_title LIKE 'Account%')
         )