I am new to SQL so bare with me here.
I have set up a contact database. The PRIMANY KEY is person.per_id
All the other tables REFERENCE the person.per_id key. Now I want to be
able
to INSERT INTO the address table based on person.per_id by name without
having to know the value of person.per_id. Something like, I know this
does not work
but you will get the idea of what I need.
INSERT INTO address
(per_id,street,city,state,zip)
VALUES ('('SELECT per_id FROM person WHERE first ='somename')','200 some
street',
'Tampa','FL','33654');
Can somthing like this be done ? Any help would be great.