Update

0

Please login or register to vote for this query.

(click on this box to dismiss)

Italian Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

create table #Staffs(StaffID int, CrewID int)
create table #Crews(CrewID int, PilotID int)
insert into #Staffs
values (1,''), (2,''), (3,'')
insert into #Crews
values (1,'3'), (2,'1')

UPDATE #Staffs
SET #Staffs.CrewID = #Crews.CrewID
FROM #Crews
WHERE #Crews.PilotID = #Staffs.StaffID;

SELECT * FROM #Staffs;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results