Article ID: 138677
Article Last Modified on 5/7/2003
CREATE SQL VIEW test AS SELECT * FROM customer ;
WHERE customer.city='London' ;
AND (customer.country='UK' ;
OR customer.postal_code='EC23NT')
This will create a view called Test. If the Test view is modified and on
the Query menu, you click View SQL, you'll see that the generated SQL
statement looks like this:
SELECT * ;
FROM tastrade!customer;
WHERE Customer.city = "London";
AND Customer.country = "UK";
OR (Customer.postal_code = "EC23NT")
Keywords: kbbug kbnofix KB138677