Open main menu

CDOT Wiki β

Changes

J.Y.S

48 bytes added, 17:07, 30 November 2010
CREATE VIEW
<pre>
CREATE VIEW PropAreaLocSeller_VU AS
SELECT SUBSTR(a(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, NVL(ag.AgencyName, 'No Agency')"Agency"
FROM Property p
JOIN Single sgl ON (p.PropertyID = sgl.PropertyID)
JOIN Area ar ON (p.AreaID = aar.AreaID) LEFT OUTER 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>
 
Not Too sure if this will work out
=Assignment 1=