Can you help to fixes the error messages and also give discretion of the query ?.

i0.087 seconds SELECT MAX (orderID) FROM Orders INNER JOIN Order items : WHERE order ID-SELECT MAX( orderID ) FROM Orders INNER JOIN Order_items): Saipt Output X e Error starting at line : 56 in command - SELECT MAX (orderID) FROM Orders INNER JOIN Order items WHERE order ID ( SELECT MAX( order!D ) FROM Orders INNER JOIN Order items) Error at Cormand Line : 58 Column : 2 Error report - SQL Error: ORA-00905: missing keyword 00905. 00000 "missing keyword" Cause: *Action