Skip to Content
0
Aug 25, 2023 at 06:37 PM

how to write this select query?

61 Views

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.