Hi,

As per Your question. i understand that u need to later the view which you created on the two tables.if yes

Then you can use Alter [viewname] [Column....] as your select...