Shorter Optimize SQL Script

[#1]

can this script be shorten?

PERIODS:

LOAD

DOCNO,

POSTDATE

FROM DOCS.QVD (qvd);

JOIN LOAD

PERIOD,

[Starting Date],

[Ending Date]

FROM [ACCOUNTINGPERIOD.QVD] (qvd);

LOAD

  DOCNO,

  POSTDATE

FROM [DOCS.QVD] (qvd);

LEFT JOIN

LOAD

DOCNO,

PERIOD

RESIDENT PERIODS WHERE POSTDATE >= [Starting Date] AND POSTDATE <= [Ending Date];

STORE * FROM SSH INTO SSH.QVD;

Shorten in a way I can lessen the number of LOADs from 4

[its_anandrjs]

Hi,

You can use like

PERIODS:

LOAD

DOCNO,

POSTDATE

FROM DOCS.QVD (qvd);

JOIN LOAD

PERIOD,

[Starting Date],

[Ending Date]

FROM [ACCOUNTINGPERIOD.QVD] (qvd);

LEFT JOIN

LOAD

DOCNO,

PERIOD

RESIDENT PERIODS WHERE POSTDATE >= [Starting Date] AND POSTDATE <= [Ending Date];

STORE * FROM SSH INTO SSH.QVD; //what is the meaning of this code

if there is table SSH so use it like

STORE SSH INTO SSH.QVD;

Rgds

Anand