i want to use the unload command to unload data of two or more items,but the data must go to one file.How can i do this.
sample that i use:
unload to b.txt select * from table where item='pea';
unload to b.txt select * from table where item='corn';
i need both outputs in the b.txt file.
But what happens is that the second one overwrites the first one.