What I need is to take the primary key from the Phone table and insert it into the FK of the Client table. How do I?

Question

What I need is to take the primary key from the Phone table and insert it into the FK of the Client table. How do I?

Asked 6 years, 6 months ago

Viewed 52 times

1

CREATE TABLE Cliente (
    id_Cliente INTEGER PRIMARY KEY IDENTITY(1,1),
    nome_Cliente VARCHAR(50),
    fk_ID_Telefone INTEGER
)

CREATE TABLE Telefone (
    id_Telefone INTEGER PRIMARY KEY IDENTITY(1,1),
    fone_Telefone VARCHAR(11)
)

when asking a question see how to format it to get more organized.

– Edu Mendonça

2018/05/11 at 14:56
As stated in the answer you can make a insert with select but for that you must specify to which customer that phone belongs. I don’t know if that’s really what you want. Try explaining again what you need and demonstrate through examples.

– Caique Romero

2018/05/11 at 15:05

1 answer

Browser other questions tagged sql sql-server

You are not signed in. Login or sign up in order to post.

by Wees Smith • **2,778** points · Answer 1 · 2018-05-11T15:00:57+00:00

Making a INSERT with SELECT:

INSERT INTO Cliente (fk_ID_Telefone) SELECT id_Telefone FROM Telefone

But if it’s a UPDATE with SELECT:

UPDATE Cliente a 
JOIN Telefone b  
SET a.fk_ID_telefone=b.id_Telefone

Reference of INSERT WITH SELECT

Reference of UPDATE WITH SELECT