Hi!
I have a problem:
i have this table Kontakt with following columns:
KONTAKTPERS_NAMN,KONTAKTPERS_TELE,KONTAKTPERS_MOBIL,KONTAKTPERS_EMAIL,ADRESS_ID

now i want to insert a new column called PLACE and insert values from an other table called ADRESS witch have following columns:
ADRESS_ID,PLACE


So i need to select the place value from Adress were ADRESS_ID is like ADRESS_ID in Kontakt

Hope you guys understood what i try to do :-)