Susan Harkins
ssharkins at gmail.com
Mon Feb 23 13:18:40 CST 2009
That's the result I got too Francisco -- I'm wondering now what put that idea into my head -- it obviously is incorrect. Thanks for verifying it! Susan H. > Within the view... you'll need to write it as: > CREATE VIEW > FROM transactions > SELECT id, quantity * cost AS [Total Cost] > WHERE quantity * cost > 100