concatenating 2 resultsets

Hi all, is it possible to concatenate two resultsets, to form a big resultset. both resultsets will return the same columns. eg query 1 returns NAME| ADDRESS| EMAIL query 2 returns NAME| ADDRESS| EMAIL but they have different data however the column count is the same (in fact they are the same column) thanx in advance Angelo -------------------------------------------------------------------- Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911