Re: View of two tables with same data

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Uri Dimant" <urid@xxxxxxxxxxx>
Date: Thu, 28 May 2009 16:55:38 +0300

Hi
Use ALIAS

select a.col AS colname1, b.col as colname2 from a join b on .......

"Spider Jerusalem" <krelespider@xxxxxxxxx> wrote in message
news:295t15hvc68arnuihusu41aif5ncjbjanr@xxxxxxxxxx

Hi, I have two tables with same fields, and I need to make view which
will get data from both tables in same fields.

References:
- View of two tables with same data
  - From: Spider Jerusalem

Prev by Date: Re: View of two tables with same data
Next by Date: Re: Msg 4104 - thought I had this nailed, but it's come back...
Previous by thread: Re: View of two tables with same data
Next by thread: Help Flattening Table
Index(es):
- Date
- Thread