Creating a view between two tables in SQL -
i'm having trouble creating view between 2 tables, i'm quite new sql. need create view show employees have carried out work consultants within past 14 days. result of view should display kind of layout: 14 day consultancy report ----------------------------------------------- employee helvin paul worked 6 hours factory ltd chargeable £351 the 2 tables assume need join employee table , consultancy table. show both below have them in text file when creating these tables: create table funtom_employee ( emp_id number(3) primary key, emp_firstname varchar2(50) not null, emp_surname varchar2(50), emp_department number(2) constraint fk_funtom_dept references funtom_department, emp_street varchar2(50), emp_town varchar2(50), emp_district varchar2(50), emp_grade number(3) default 4 constraint chk_emp_grd check (emp_grade between 1 , 9), emp_site varchar2(30) default 'london', constraint fk_funt...