sql view 1

[ianholmes]

I am a cobol programmer who is new to SQL.
I need to create a VIEW to to merge the contents of 2 tables, whose fields are the same.
eg Table 1 & 2 both have : Key, Date, & Amount.
Table 1 has data up to yesterday.
Table 2 has today's data.
When I use the VIEW, I want to be able to access all of Table 1 & table 2's data as if they were in the same table.
This is probably dead easy, but I don't know how.
Many Tahanks in anticipation.
Ian

 

[magicrat]

Search help for "UNION"

 

[ianholmes]

Thanks magicrat, but my development environment doesn't allow UNIONs within a VIEW.
I know how to use a UNION, but, in this instance, I must
write a VIEW to achieve the merge.
Can you suggest anything else ?
Best Wishes