why doesn't this work? the select works perfectly
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
