This shows you the differences between two versions of the page.
— |
kurs:kopieren_von_einer_anderen_tabelle [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code> | ||
+ | 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%') | ||
+ | ) | ||
+ | </code> |