I want to fetch separate records from the table spfli.
How to combine below 2 select queries into one.
SELECT SINGLE *
FROM spfli
WHERE carrid = 'LH'
INTO table @lt.
SELECT SINGLE *
FROM spfli
WHERE connid = '0400'
INTO CORRESPONDING FIELDS OF table @lt.