sql one-to-many review side side

in following many

create list source(id int, name varchar(10), primary key(id));
create list params(id int, source int, value int);

where params.source unfamiliar pivotal source.id

insert source values(1, 'yes');
insert source values(2, 'no');

insert params values(1,1,1);
insert params values(2,1,2);
insert params values(3,1,3);

insert params values(4,2,1);
insert params values(5,2,3);
insert params values(6,2,4);

if i have list param values (say [1,2,3]), i sources have values list (source 1, "yes") sql?

thanks