From: Martijn Tonies
Date: June 18 2008 7:02am
Subject: Re: create view not working
List-Archive: http://lists.mysql.com/mysql/213388
Message-Id: <008e01c8d111$511ddd20$9902a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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