CREATE DATABASE BusinessTripsSNF

CREATE TABLE BusinessTripsSNF.dbo.Researcher
(
	rNo VARCHAR(50) NOT NULL,
	rName VARCHAR(50),
	CONSTRAINT PK_rNo PRIMARY KEY (rNo)
)

INSERT INTO BusinessTripsSNF.dbo.Researcher
	SELECT DISTINCT rNo, rName FROM BusinessTripsUNF.dbo.ResearcherConference