yea it can be done easily using views in sql server as well as oracle