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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]