ora 923ERROR: ORA-00923: FROM keyword not found where expected. How may I fix this. Thanks in Advance! still i got the error. specify the table. Instead of *, use brand.*, PRDUCT.*,You are missing the comma between them. Which is why Oracle believes the word FROM was missing at the end of the third . Fix this and