> 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
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!