Can we able to create database view?

Thanks for your reply. But Iam looking something different. Say I have user and blog details tables and a user can post multiple blogs. And I have to list all blogs along with the user details such as user name and some other personal information’s. The link which you have given might help me incase if my use case is show blogs upon selecting user.