Trying to create a linking table [closed]

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers. Want to improve this question? Update the question so it’s on-topic for Stack Overflow. Closed 11 hours ago. Improve this question CREATE TABLE patient ( patientid INT NOT NULL, patientname VARCHAR(100), patientphone VARCHAR(100), CONSTRAINT PK_patient PRIMARY KEY (patientid) ) CREATE TABLE doctor ( doctorid …