Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Materialized view appending two tables

Status
Not open for further replies.
zhonghandle

zhonghandle

Programmer
Jul 17, 2002
12
US
Hi,

I have two tables (t1 and t2) of same structure. The contents of two tables are different. Now I have to create a materilized views that append t1 and t2 together. Since materilized views do not allow 'Union', do anyone has a way to handle this or know any work-arounds?

Thanks alot in advance!
 
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
938
Mike Lewis
Mike Lewis
briangriffin
  • Locked
  • Question
Calculating differences every two rows
Replies
2
Views
713
kjv1611
kjv1611
Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
556
Chris Miller
Chris Miller
ms901Boss
  • Locked
  • Question
Joining two select statement into one
Replies
1
Views
332
kray4660
kray4660
ms901Boss
  • Locked
  • Question
Join two select statements and collecting data from both
Replies
13
Views
687
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top