can I join views in Oralce ?
Posted on 2007-10-14
I have most of my stuff in sql server 2000, now I have a project in Oralce. Can I join three views in Oracle ?
I have three views , test1_view , test2_view, test3_view
test1_view - custID
test2_view - custID
test2_view - prodID
test3_view - prodID
I need to join (inner join) all these three views test1_view custID and test2_view on custID,
test2_view and test3_view on prodID. Also how can I give aliases to these views in oracle ?