Changes

J.Y.S

259 bytes added, 15:15, 1 December 2010

→‎CREATE VIEW

JOIN Deed d ON (p.PropertyID = d.PropertyID)

JOIN Client s ON (d.SellerID = s.ClientID);

</pre>

==== Display data from VIEW ====

<pre>

Normal 0 false false false EN-US X-NONE X-NONE

SELECT *

FROM PROPAREALOCSELLER_VU

WHERE INSTR("Property Location", 'Bayview Village') !=0

AND INSTR("Agency", 'Sutton') !=0;

</pre>

1

edit