I'm currently trying to draw multiple tables through several inner-join statements. However, I am continually hit with the following error:
ORA-00904: "PART"."ITEM_CLASS": invalid identifier
I've visited several other pages here but that problem did not coincide with mine.
Here is the SQL query:
SELECT Slsrep_Number, AVG(Commission_Rate) AS AVG_Rate, MAX(Total_Commission) as MAX_Comission FROM Sales_Rep WHERE Sales_Rep.Slsrep_Number = Customer.Slrsrep_Number AND Customer.C_Number = Orders.C_Number AND Orders.Order_Number = Order_Line.Order_Number AND Order_Line.Part_Number = Part.Part_Number AND Part.Item_Class = 'SG';
Here are the tables being used (screenshots):
The pictures are listed in the order that I am referencing them in the SQL query.