SELECT e.last_name, j.start_date, j.end_date, s.job_id from employees e, jobs_history j, jobs s

SELECT e.last_name, e.email, j.department_id, e.salary from employees e, jobs_history j where salary between 0.00 and 1000.00

$sql = "INSERT INTO persons_martin_erik_pille1 (TUDENG, SISSEASTUMISE_AASTA, HINNE) VALUES ('$TUDENG','$SISSEASTUMISE_AASTA', '$HINNE')";


mysql> SELECT t1.*, t2.* FROM t1, t2;


INSERT INTO <target table> (<columns>) SELECT <columns> FROM <table 1> UNION SELECT <columns> FROM <table 2>;