Re: ORA-00942: table or view does not exist

Thanks for your response, this helps but the error message has started reappearing. This time under the 'h' in vehicle!

I have reduced the statement to this, and the error seems to appear on line 2, under vehicle.

select book_ref,sum(veh_rate*rent_days) from owner.booking,owner.vehicle,owner.bookline group by book_ref;

Regards,

Ben Knill
timkarnold wrote:
>
>
> Who owns the tables booking, customer ,vehicle,book_line ?
> Try owner.booking, owner.customer etc.
>
> <ben_knill_at_hotmail.com> wrote in message
> news:tcmbvi4a3vr09a_at_corp.supernews.com...
> > I am trying to create a view to use as a report, I keep getting this
 error
> > message when it does'nt seem to recognise the tables customer, and
> > booking.
> > These tables DEFINATLY exist but I don't seem to be able to get around
> > this problem. Could someone give me some advise on creating this view!
> > The telnet response is:
> >
> > SQL> Create view customer_sales as
> > select cust_name, book_ref, sum(veh_rate*rent_days) "BOOKING COST"
> > from booking, customer ,vehicle,book_line
> > where customer.cust_no = booking.cust_no and
> > booking.book_ref = bookline.book_ref
> > group by cust_name;
> >
> > 2 3 4 5 6 from booking, customer ,vehicle,book_line
> > *
> > ERROR at line 3:
> > ORA-00942: table or view does not exist
> >
> >
> > SQL> SQL> Create view customer_sales as
> > select customer.cust_name, booking.book_ref, sum
> > (veh_rate*rent_days) "BOOKING C
> > OST"
> > from booking, customer ,vehicle,book_line
> > where customer.cust_no = booking.cust_no and
> > booking.book_ref = bookline.book_ref
> > group by cust_name;
> > 2 3 4 5 6 from booking, customer ,vehicle,book_line
> > *
> > ERROR at line 3:
> > ORA-00942: table or view does not exist
> >
> >
> > --
> > Posted via CNET Help.com
> > http://www.help.com/
>
>

--
Posted via CNET Help.com
http://www.help.com/