List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:June 18 2008 7:02am
Subject:Re: create view not working
View as plain text  
Aaron,

> why doesn't this work? the select works perfectly

Define "doesn't work"? What is the error message?

> create view cost_report as
> SELECT c_name, d_manuf as Manufacturer, d_model as Model, count(1) as
> "Number Enrolled",
> d_price as "Monthly Price", count(1)*d_price as "Cost"
> FROM `b_devices` A
> left join b_device_types B
> on A.d_id = B.d_id
> left join b_prices C
> on A.d_id = C.d_id AND A.c_id = C.c_id
> left join b_company D
> on A.c_id = D.c_id
> group by A.d_id, A.c_id
> order by c_name

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Thread
create view not workingAaron Ryden18 Jun
  • Re: create view not workingMartijn Tonies18 Jun