1
edit
Changes
→CREATE VIEW
==== CREATE VIEW ====
<pre>
CREATE VIEW PropAreaLocSeller_VU AS
SELECT (a.AreaName || p.City || p.Street || p.PostalCode) "Property Location", p.ListingPrice, sgl.LotSize,
s.Lname || ', ' || s.Fname, s.phone, d.OwnPct, ag.AgencyName
FROM Property p
JOIN Single sgl ON (p.PropertyID = sgl.PropertyID)
JOIN Area ar ON (p.AreaID = a.AreaID)
JOIN Agency ag ON (p.AgencyID = ag.AgencyID)
JOIN Deed d ON (p.PropertyID = d.PropertyID)
JOIN Client s ON (d.SellerID = s.ClientID)
</pre>
=Assignment 1=
