SyntaxFix
Write A Post
Hire A Developer
Questions
You want:
insert into prices (group, id, price) select 7, articleId, 1.50 from article where name like 'ABC%';
where you just hardcode the constant fields.