Usage of LOAD....SQL SELECT Statement

[#1]

Hi,

Could you please tell me the advantage of LOAD ... SQL SELECT and when we need to use this?

Is that we can use the QlikView functions in the LOAD and Database functions in the SQL SELECT part as
LOAD would manipulate in QlikView and SQL SELECT would manipulate in database.? Is this correct.

Example:

LOAD floor(date(CREATION_TS)) as TS,
....

SQL SELECT MAX(CREATION_TS)
FROM sample.

The order of the LOAD and SQL SELECT can differ?correct?

[#2]

Good day

I use the Load … SQL in the following case ..

For example  cargo application has two tables and we want to link two filed with different names but with same content ..

               AWBN   and   AWBSEQ  

So the following can be used in the loading script

SQL

SELECT * FROM XXXX;

LOAD AWBN AS AWBSEQ ;

SQL

SELECT * FROM YYYY;

brgds

J.Saudi