User Tools

Site Tools


kurs:kopieren_von_einer_anderen_tabelle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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>​
kurs/kopieren_von_einer_anderen_tabelle.txt · Last modified: 2014/09/10 21:22 (external edit)