Re: Creating a view

Vern Reynolds wrote:
> Hello experts,
>

 <snip>
> I get this message in Oracle...
>
> SQL> create view vern (ssopen, ssclose, wsopen, wsclose)
> 2 as SELECT TITLE from HYMNAL, SCHEDULE
> 3 where HYMNAL.PAGE=CHURCH.SCHEDULE.SSOPENINGHYMNNUMBER
> 4 where HYMNAL.PAGE=CHURCH.SCHEDULE.SSCLOSINGHYMNNUMBER
> 5 where HYMNAL.PAGE=CHURCH.SCHEDULE.WSOPENINGHYMNNUMBER
> 6 where HYMNAL.PAGE=CHURCH.SCHEDULE.WSCLOSINGHYMNNUMBER;
> where HYMNAL.PAGE=CHURCH.SCHEDULE.SSCLOSINGHYMNNUMBER
> *
> ERROR at line 4:
> ORA-00933: SQL command not properly ended
>
>
> SQL> /
> where HYMNAL.PAGE=CHURCH.SCHEDULE.SSCLOSINGHYMNNUMBER
> *
> ERROR at line 4:
> ORA-00933: SQL command not properly ended
>
> Could someone explain what I'm doing wrong?
>
> Thanks,
>
> Vern
>
>
>
 

 >   3  where HYMNAL.PAGE=CHURCH.SCHEDULE.SSOPENINGHYMNNUMBER
 >   4  AND HYMNAL.PAGE=CHURCH.SCHEDULE.SSCLOSINGHYMNNUMBER
 >   5  AND HYMNAL.PAGE=CHURCH.SCHEDULE.WSOPENINGHYMNNUMBER
 >   6  AND HYMNAL.PAGE=CHURCH.SCHEDULE.WSCLOSINGHYMNNUMBER;
 

-- 
Regards, Frank van Bortel