1
edit
Changes
→CREATE VIEW
<pre>
CREATE VIEW PropAreaLocSeller_VU AS
SELECT (a.AreaName || ', ' || p.City || ', ' || p.Street || ', ' || p.PostalCode) "Property Location", TO_CHAR(p.ListingPrice,'$9,999,999'), sgl.LotSize || ' sqft' LotSize, s.Lname || ', ' || s.Fname, s.phone, d.OwnPct, NVL(ag.AgencyName, 'No Agency')
FROM Property p
JOIN Single sgl ON (p.PropertyID = sgl.PropertyID)
JOIN Client s ON (d.SellerID = s.ClientID)
</pre>
Not Too sure if this will work out
=Assignment 1=
