ora-00904 00904.00000-"%s: invalid identifier"
508050Apr 11 2007 — edited Apr 12 2007i 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