Re: NULLS in UNION of two tables

On Mon, 01 Jun 1998 15:04:06 -0500, Julie A Peronto <jperont_at_entergy.com> wrote:

>I am creating a view that is the union of two tables that hold different
>information about like objects. There are some fields that exist in
>both tables & other fields that exist in one or the other table.
...big snip...

Forgive me if I am misunderstanding your problem. I think you would be better served with a join instead of a union.

select table_1.wr_no, table_1.wr_type, table_2.wr_status
from   table_1, table_2
where  table_1.wr_no = table_2.wr_no;

Would this work?
Mark Woytus (w)309.888.8423 (f)309.888.8246 Diversified Computer Consultants
mwoytus_at_divcomp.com woytus_at_acm.org Received on Mon Jun 01 1998 - 23:31:04 CEST