ora 923ORA-00923: FROM keyword not found where expected SQL: SELECT DISTINCT B10.EMPLID from PS_BEN_PROG_PARTIC a10, PS_EMPLOYEES b10,SQL Error: ORA-00923: FROM keyword not found where expected. Can anyone tell me where I'm going wrong with this? you don't need the WITHIN GROUP clause. it's ok