sql formatting
SELECT report_id, NODE_HIERARCHY,TEST_STATUS, TEST_VERDICT, TEST_COMMENTS, TEST_TYPE FROM TESTFLOW_TEST_RESULTS WHERE TEST_TYPE = 'fip' and report_id=1304;
SELECT report_id, NODE_HIERARCHY,TEST_STATUS, TEST_VERDICT, TEST_COMMENTS, TEST_TYPE FROM TESTFLOW_TEST_RESULTS WHERE TEST_TYPE = 'iolm' and report_id=1304;
SELECT report_id, NODE_HIERARCHY,TEST_STATUS, TEST_VERDICT, TEST_COMMENTS, TEST_TYPE FROM TESTFLOW_TEST_RESULTS WHERE TEST_TYPE = 'iolm' and report_id=1304;
1st return 18 raws, 2nd return 3 raws, 3rd retun 3 raws.
I need below output..
1st sql result 2nd sql result 3rd sql result
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OVP1|ToOVP2|Alpha|Alpha-OVP1-ToOVP2-A |