View (SQL): Difference between revisions

Content deleted Content added
added more content
Line 25:
== Equivalency ==
A view is equivalent to its source query. When queries are run against views, the query is modified. Ie if there exists a vie named Accounts_view and the content is
<code>
SELECT name,
money_received,
money_sent,
Line 34 ⟶ 35:
FROM table_customers c
JOIN accounts_table a
ON a.customerid = c.customer_id
</code>
 
The application would simply run a simple query such as: