SQL & PL/SQL

i first tested the the my sql with this statement and found this error that the beiw or table does not exist.


i then added the schema name before the table
and it works fine.

SELECT
*
FROM
Tschema.Ttable
where Ttable.NOTXT like '%HHHH%'


i then have my actual query and i it is not working

i am getting this error
ora-00904 00904.00000-"%s: invalid identifier"



SELECT

SFPROPERTY.PINNER,
TABCASER.CASERTYPSEEDEE,
TABCASER.CASERNUMBERING ,
SFPROPERTY.CosulDee_no ,
TABCASER.SESEADOPTDATE ,
TPCPCASER.PCPACTINGADVIDINGDATE ,
SFPROPERTY.STREETFRACNO,
Treferrence_Pl_Ar.PLAAYEDES,

TAPLICATOR.PROdesc
FROM
Schma.SFPROPERTY
LEFT JOIN Treferrence_Pl_Ar ON SFPROPERTY.PLAREEYANOMbOR = Treferrence_Pl_Ar.PLAREEYANOMbOR
INNER JOIN TEELOCATOR ON SFPROPERTY.PROP_ID = TEELOCATOR.LOOKEYEDEE
INNER JOIN TAPLICATOR ON TEELOCATOR.APPEYEDEE = TAPLICATOR.APPEYEDEE
INNER JOIN TABCASER ON TAPLICATOR.APPEYEDEE = TABCASER.APPEYEDEE
INNER JOIN TPCPCASER ON TABCASER.casereyedee = TPCPCASER.casereyedee
where TABCASER.CASERNUMBERING like '%raa%'
and SFPROPERTY.CosulDee_no = 80



HELP on my query

thanks