select place_code, place_name from cprdb.places where place_code in (select distinct parish_code from cprdb.) order by place_code
                                                                                                             *
ERROR at line 1:
ORA-00903: invalid table name