how to store data in a table

[taz803]

i have a request

test1 : select from many tables and with join and where and group by i want to store the result of this request in a another table . 

i tried :

test2:

load * from test1 and it doesn't work .

how can i handle it 

[vikasmahajan]

hi,

you need to use word resident:

test:

Load  * from xyz;

test2:

Load * from pqr ;

join (test2)

load * resident test ;

drop table test;

STORE test2 INTO 'lib://QVdata/test2.qvd' (qvd);

or 

STORE test2 INTO 'lib://QVdata/test2.qvd' (CSV);  in case you wanted to store into CSV format.

Vikas