Re: combining rows from 2 tables
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Fri, 19 Sep 2003 12:55:42 +0200
Message-ID: <1063968588.828514_at_news.thyssen.com>
Date: Fri, 19 Sep 2003 12:55:42 +0200
Message-ID: <1063968588.828514_at_news.thyssen.com>
"jt" <judiphuongtu_at_yahoo.com> schrieb im Newsbeitrag
news:6f38222f.0309172047.111558b6_at_posting.google.com...
> Is there a way to create a view that combines all rows from 2 tables
> that have the same columns/fields?
>
> thanks,
> Judi
Hi Judi,
minor addition to what 'osy45' and Sybrand wrote:
performance will be better if you make it a
UNION *ALL*.
Greetings,
Guido
Received on Fri Sep 19 2003 - 12:55:42 CEST