Category : Files from Magazines
Archive   : DBMS9104.ZIP
Filename : SQL1.APR

 
Output of file : SQL1.APR contained in archive : DBMS9104.ZIP


CREATE VIEW customer (c#, name, city) AS
SELECT customer_name.c#, name, customer_site.city
FROM customer_name, customer_site
WHERE customer_name.c# = customer_site.c#
AND customer_site.type = `HQ';