want to create an view in magento 2.1.7. As we do create in mysql, how to do it?? want to do it progmatically.
You can find more info about view here https://dev.mysql.com/doc/refman/5.7/en/create-view.html
But I do not see the sense to create view, you can create tempopary table using