Home » RDBMS Server » Server Administration » Re: Creating a view with 3 tables
Re: Creating a view with 3 tables [message #372947] Mon, 19 March 2001 17:11
Joachim Lindner
Messages: 30
Registered: February 2001
Member
No idea what the source of problem is, but what's wrong with this ?

Create or replace view vwTest1 (cust, custnum, order)
as
select tablea.cust, tableb.custnum, tablec.order
from tablea, tableb, tablec
where tablea.cust_id = tableb.cust_id
and tableb.cust_name = tablec.cust_name;

Report message to a moderator

Previous Topic: How do I combine multiple rows into one row like this..?
Next Topic: Oracle and Informix via ODBC
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 04:31:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.