Query result merge/ format
I have four different SQL as below.. I want to merge in one SQL and display all records in below format.
TEST_INSTANCE_ID | MAXSPLICELOSS | WAVELENGTH | TEST_INSTANCE_ID | TEST_INSTANCE_ID | WAVELENGTH_ELEMENT_EXT | TEST_INSTANCE_ID | APPLYMINLINKLOSS | TEST_INSTANCE_ID | LINK_ORL_EXT |
2812 | 1 | 1550 | 2812 | LinkEnd, EndOfFiber, NotOnLink | 1310 | 2812 | TRUE | 2812 | 32.6 |
2812 | None | 1550 | 2812 | 32.52 | |||||
2812 | LinkEnd, EndOfFiber, NotOnLink | 1550 | 2812 | 33.04 | |||||
2812 | LinkEnd, EndOfFiber, NotOnLink | 1490 | |||||||
2812 | LinkStart | 1490 | |||||||
2812 | None | 1490 |
SELECT DISTINCT VET.TEST_INSTANCE_ID,
VET.MAXSPLICELOSS,
VET.WAVELENGTH
FROM V_ECBIIOLM_ELETHRESHOLDSGRP VET
WHERE VET.PARAM_GROUP_ID IN (1550,15502,15504,15508,155016,155032,155064,1550128,1233989949,1749708779)
AND VET.TEST_INSTANCE_ID = 2812;
SELECT DISTINCT IED.TEST_INSTANCE_ID,
IED.TYPE_ADD_INFO_ELEMENT,
IED.WAVELENGTH_ELEMENT_EXT
FROM IOLM_ELEMENT_DETAILS IED