Hi! how to minimize my 3 queries into 1? is

Question

Hi! how to minimize my 3 queries into 1? is

it possible?
INSERT INTO table1 (SUB_ID, LR_ID)
SELECT ID, 3
FROM table2
WHERE ACTIVE = 'Y';

INSERT INTO table1 (SUB_ID, LR_ID)
SELECT ID, 4
FROM table2
WHERE ACTIVE = 'Y';

INSERT INTO table1 (SUB_ID, LR_ID)
SELECT ID, 5
FROM table2
WHERE ACTIVE = 'Y';

#english #programming #sql

0

17.07.2024

2 ответов

14 просмотров

Askhat Автор вопроса

yes, i need in table1 for each ID 3 rows with different LR_ID: 3,4 and 5

0

3 месяца назад

Rafael Dias · Accepted Answer

Rafael Dias

INSERT INTO table1 (SUB_ID,LR_ID) SELECT ID, 3 FROM table2 WHERE ACTIVE = 'Y' union all SELECT ID, 4 FROM table2 WHERE ACTIVE = 'Y' union all SELECT ID, 5 FROM table2 WHERE ACTIVE = 'Y';

0

3 месяца назад

169 похожих чатов

Hi! how to minimize my 3 queries into 1? is

2 ответов

Похожие вопросы