...

CREATE TABLE Employees (

LastName varchar(30) NOT NULL,

FirstName varchar(30) NOT NULL,

EmployeesID VARCHAR(20) NOT NULL,

Certifications varchar(20),

Payrate varchar(20),

PRIMARY KEY (EmployeesID) );

CREATE TABLE Certifications (

HighRise varchar(30) NOT NULL,

ToxicWaste varchar (30) NOT NULL,

Level2DL varchar(30) NOT NULL,

CertificationID int NOT NULL,

Paramedic varchar(20),

EmployeesID INT,

LastName varchar(30) NOT NULL,

FirstName varchar(30) NOT NULL,

PRIMARY KEY (CertificationID));

i am trying to Execute one join command to display all of the data included in the two tables for each set of tables

Why am i receiving this error in my SQL?

SQL> SELECT Employees.LastName , Employees.FirstName , Employees.EmployeesID, Certifications, Payrate, HighRise, ToxicWaste, Level2DL, CertificationID, Paramedic 2 FROM Employees EMP 3 INNER JOIN 4 Certifications 5 ON EMP.EmployeeID=Certifications.EmployeeID; ON EMP.EmployeeID=Certifications.EmployeeID * ERROR at line 5: ORA-00904: "CERTIFICATIONS"."EMPLOYEEID": invalid identifier