Hi All, As per my requirement, I need a VIEW which gives a resultset from multiple tables. But my requirement is little different, what I wants that the Select statement should join with another select statement to get my resultset for which I need to create one more inner view which I don't wants. Is it possible to write more than one select statement in a view? If not then how can I achieve my goal now...? I don't really need an extra view to get the required output. Can someone please help me for this? Even I know it can be achive by CTE but i want to use a view rather than sql statements because i am using this view for my report purpose. Thanks, Sandy.