ИС
навскидку...
tmp:
NoConcatenate LOAD id,open as dt,'open' as type Resident open;
Concatenate(tmp) LOAD id,close as dt,'close' as type Resident close;
data: NoConcatenate LOAD * Resident tmp order by id,dt;
drop Tables open,close,tmp;
tmp:
NoConcatenate LOAD id,open as dt,'open' as type Resident open;
Concatenate(tmp) LOAD id,close as dt,'close' as type Resident close;
data: NoConcatenate LOAD * Resident tmp order by id,dt;
drop Tables open,close,tmp;
