3 ms·
joins and subqueries are part of SELECT statements, not crud. the purpose of using views is for the SELECT side of the application, not the CRUD side.
by zzzeek 3y ago
joins and subqueries are part of SELECT statements, not crud. the purpose of using views is for the SELECT side of the application, not the CRUD side.
- spikej 3y agoYou're describing the "R" in CRUD, my friend: https://en.wikipedia.org/wiki/Create,_read,_update_and_delete https://en.wikipedia.org/wiki/Create,_read,_update_and_delet... In the example above, the select statements were inside stored procedures, and applications were only granted permissions to execute those with appropriate parameters.