Single view on multiple tables?

From: Ken Rachynski <krachyn_at_cadvision.com>
Date: Thu, 18 Feb 1999 10:48:03 -0700
Message-ID: <36CC5253.28CA4215@cadvision.com>

Good day,

I'm not sure if I have seen this done or not, but:

I have several tables that hold different data with a similar key. Basically, I have a parts orders table with key values in the 60k range and a work orders table with key values in the 80k range, etc. I would like to create a view that displays the key value and another field that is common to all the tables. Is this possible?

Thanks in advance for any answers.

--
Ken Rachynski
Database Analyst
krachyn_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514 Received on Thu Feb 18 1999 - 11:48:03 CST