Probleme projet sql

stephenking -  
 stephenking -
Bonjour, j'ai besoin d'un coup de main.
Pouvez-vous m'aide à resoudre ce probleme?

Voici ma vue :
spool vue

create or replace view RBaseTicket as
select numS, dateRep, noPlace, noRang, statut
from LesRepresentations_base natural join LesTickets ;

Select * from RBaseTicket;

create or replace view LesRepresentations as
select RBaseTicket.numS as numS, RBaseTicket.dateRep as dateRep,
P.numZ as numZ, RBaseTicket.statut as statut,
RBaseTicket.noPlace as noPlace, RBaseTicket.noRang as noRang
from ( LesPlaces P left outer join RBaseTicket )
on ((P.noPlace <> RBaseTicket.noPlace
and P.noRang <> RBaseTicket.noRang)
or (P.noPlace is null and P.noRang is null))
where (P.noPlace is null and P.noRang is null);

Select * from LesRepresentations;

spool off

voici le reponse de sqlplus :

from ( LesPlaces P left outer join RBaseTicket )
*
ERROR at line 5:
ORA-00905: missing keyword

Merci à toutes les personnes qui répondrons.
A voir également:

1 réponse

stephenking
 
VIVE LA SOLIDARITE
0