View and Tables

Question

Hi,

 

i have two tables like Table A and Table B

 

and one view

 

 my question is i merge two tables

 

Table A union Table B ....fine

 

Table A having 10 columns and Table B having 5 columns (this join is not possible)..fine

 

the remaining 5 columns is having from my view.

 

now i want to union A and B(table columns 5 + view columns 5)

 

how can i use table and view both in same time

 

thanks

vijay