can't create view

[attaboy]

The following was working fine till put the WHERE LifeExpectancy NOT NULL clause in.

 

CREATE VIEW loDensity AS
SELECT Name, SurfaceArea, Population,
Population / SurfaceArea AS popDensity,
LifeExpectancy
FROM country
WHERE LifeExpectancy NOT NULL
ORDER BY popDensity
LIMIT 10;

 

[awjudd]

Because that is an invalid query.  It should be IS NOT NULL.

 

CREATE VIEW loDensity AS
SELECT Name, SurfaceArea, Population,
Population / SurfaceArea AS popDensity,
LifeExpectancy
FROM country
WHERE LifeExpectancy IS NOT NULL

 

With views, when in doubt, just try to copy and past the SQL and see the error message.

 

~awjudd

[attaboy]

That did it thanks much!!!