How to write sql script in Qliksense editor script

[mahnoor1279]

Hello everyone 

I want to ask that how can i write the following script into  script editor 

SELECT

K.FIRST_NAME, K.AOP_SNO, K._ADDRESS, K.CITY

FROM DIGITAL_ACCT_MAIN M,       DIGITAL_KYC K ,     ACCT_OPENING O
WHERE M.AOP_SNO = K.AOP_SNO
AND O.AOP_SNO = M.AOP_SNO
AND K.RESULT= 'ok'                                                                                                                                                                                                          AND K.VERISYS = 'ok'                                                                                                                                                                                                              AND O.ACCT_REJECT IS NULL
AND TRUNC(M.START_DATE) BETWEEN '01JAN2023' AND '31JAN2023'

AND K.AOP_DIGITAL_KYC_SNO = (SELECT MAX(KYC.DIGITAL_KYC_SNO)
FROM DIGITAL_KYC KYC WHERE KYC.AOP_SNO = M.AOP_SNO);

[Or]

Exactly as-is. There's no problem with using an SQL query in Data Load Editor.

[chriscammers]

Don't forget your connection.

When working with databases you need to connect to the database then once you have connected you can use as many sql queries as you like. Then if you want to change connections issue annother connect command and use as many sql commands against that database as you wish

Good luck