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
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
I believe CREATE VIEW came in with 5.01, not 4.1.x.
PB
sirisha gnvg wrote:
we are working on mysql 4.1.8 and windows XP platform.
This version supports views.We created a view like this
mysqluse sample
mysqlcreate view v1 as select * from sam2;
sam2 is a table
We got an error
errror
we are working on mysql 4.1.8 and windows XP platform.
This version supports views.We created a view like this
mysqluse sample
mysqlcreate view v1 as select * from sam2;
sam2 is a table
We got an error
errror 1024(42000):you have an error in your sql syntax;
we checked the manual
sirisha gnvg wrote:
we are working on mysql 4.1.8 and windows XP platform.
This version supports views.We created a view like this
mysqluse sample
mysqlcreate view v1 as select * from sam2;
sam2 is a table
We got an error
errror 1024(42000):you have an error in your sql syntax;
we checked the