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

<p><font face="Arial" size="2">Hello,</font><p><font face="Arial" size="2">I'm not sure if this is even possible, but
I'llthrow it by you anyway.  </font><p><font face="Arial" size="2">Say I have 2 tables:</font><p><font face="Arial"
size="2">Table1: With columns number and name </font><p><font face="Arial" size="2">1.1     test1</font><br /><font
face="Arial"size="2">1.2     test2</font><br /><font face="Arial" size="2">1.3     test3</font><br /><font face="Arial"
size="2">1.4    test4</font><p><font face="Arial" size="2">Table2: With column number and results</font><p><font
face="Arial"size="2">1.1     pass</font><br /><font face="Arial" size="2">1.2     fail</font><br /><font face="Arial"
size="2">1.3    pass</font><br /><font face="Arial" size="2">1.4     fail</font><p><font face="Arial" size="2">What I
wouldlike 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:</font><p><font face="Arial" size="2">1.1     pass    test1</font><br /><font face="Arial"
size="2">1.2    fail    test2</font><br /><font face="Arial" size="2">1.3     pass    test3</font><br /><font
face="Arial"size="2">1.4     fail    test4</font><p><font face="Arial" size="2">**NOTE: in same cases if you do a
"selectname from table1 where number='1.1'" you might get multiple matches, I guess we would need to use "distinct"
?</font><p><fontface="Arial" size="2">I've never interacted two tables before, so I'm not even sure where to start with
this.</font><p><font face="Arial" size="2">I'm using postgres 7.4.   </font><p><font face="Arial" size="2">Thanks all.
</font>

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);