Re: DB question - Merging data from one table to another.

On Thu, 1 Apr 2004, malia, sean wrote:

> Hello,
> 
> I'm not sure if this is even possible, but I'll throw it by you anyway.  
> 
> Say I have 2 tables:
> 
> Table1:  With columns number and name 
> 
> 1.1    test1
> 1.2    test2
> 1.3     test3
> 1.4    test4
> 
> Table2: With column number and results
> 
> 1.1    pass
> 1.2    fail
> 1.3    pass
> 1.4    fail
> 
> What I would like to do is add a new column to Table2 called name and
> populate the name from table 1 and add it to table 2.  So, table 2 will look
> like:
> 
> 1.1    pass    test1
> 1.2    fail    test2
> 1.3    pass    test3
> 1.4    fail    test4

You may want to consider using a view to do this, especially if you don't 
have a 1:1 correspondence.  I.e. there are a lot of entries in table2 for 
1.1 etc...

create view bigview as 
select * 
from table2 t2 
join 
table1 t1 
on
(t2.number=t1.number);