How can I query?

[gabrielefrank]

Hello,
how can I write this query
INSERT INTO TAB2
SELECT 1,
2,
3,
4,
5,
COALESCE(MAX(NU M),(SELECT MAX(NUM) FROM TAB1 WHERE
CD_TYPE = '00')),
COALESCE(MAX(PR G_NUM),0)
FROM TAB1
WHERE CD_TYPE= '00' AND CD_SUBTYPE = '999999999'
Being carefull at first "COALESCE".
Thankyou
G