adding the output of one table/table to another 2

[nuct]

Hi,

is it possible to add the output of one view to another for example:

This...

name gender
------- -------
kenith male
malcombe male

name gender
------- -------
waynetta female
ethel female

would become this...

name gender
------- -------
kenith male
malcomb male
waynetta female
ethel female

Any help would be appreciated.

Simon

 

[nuct]

That table/table bit is supposed to say table/view.

Cheers

Simon

 

[grega]

You could try ...

select * from view1
union
select * from view2

.. which would work for your example above. Duplicates would be ignored though.

Greg.

 

[carp]

Duplicates will be eliminated with a UNION.
If you want to include duplicate rows, use UNION ALL.

 

[nuct]

Most excellent, Thanks

Simon.