1
edit
Changes
→CREATE VIEW
CREATE VIEW PropAreaLocSeller_VU AS
SELECT SUBSTR((ar.AreaName || ', ' || p.City || ', ' || p.Street || ', ' || p.PostalCode), 1, 60) "Property Location",
TO_CHAR(p.ListingPrice,'$9,999,999') "Listing Price", sgl.LotSize || ' sqft' "LotSize", s.Lname || ', ' || s.Fname "Full Name", s.phone "Phone", d.OwnPct"OwnPct", NVL(ag.AgencyName, 'No Agency') "Agency"
FROM Property p
JOIN Single sgl ON (p.PropertyID = sgl.PropertyID)
