Re: SQL - View with two tables?

Xaver Trapichler wrote:

> ... thanks a lot, I did it and it works great ...
>
> Xaver

While it may have worked group ... I would make the following suggestion.

1. Use UNION ALL as it is substantially faster unless you have a need to exclude duplicates ... identical information appearing in both tables.
2. Having two tables with identical structure is a violation of every rule of data normalization of which I can think. The two tables should be merged into one with an added column indicating the data type of the corresponding record. What you are doing is never necessary and should never be done.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)