By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table Person (person_id int,firstName int,middleName int,lastName int)
create table Ballot (firstName int,middleName int,lastName int,voter_Id int)
insert into Ballot values ( 123, 123, 123, 0)
select * from Person
person_id |
firstName |
middleName |
lastName |
|---|
Insert into Person(person_id, firstName, middleName, lastName)
Select Distinct -1, firstName, middleName, lastName
from Ballot B
where voter_Id = 0
select * from Person
person_id |
firstName |
middleName |
lastName |
|---|---|---|---|
-1 |
123 |
123 |
123 |