1
edit
Changes
→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>
