SQL query question?

[roger westin]

Hi there,

So a question....
I have two tables. And i want to... (i just show you)

Table 1.

Owner    Char(30)    Uniqe
File        Char(80)
OID        int                            (not in use yet)


Table 2.
ID            int            uniqe and so on
Owner    Char    
Name    Char
adress
etc
....

So I want to give the OID in table 1 the corresponding ID from Table 2 so that I may 
remove The Owner Col.
I can do it with using tmp tables and so on, ( my knowlage in SQL querys is wery 
limited), But I want to do it 
with Just ONE singel SQL line....

Any ideas?

/roger