Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need To Dummy-Down Oracle

Re: Need To Dummy-Down Oracle

From: Doug Stone <dstone_at_res-q.com>
Date: Sun, 6 Dec 1998 15:42:39 -0800
Message-ID: <OQyiLHXI#GA.298@nih2naab.prod2.compuserve.com>


Jim:
>Ahh... the following query will give you a problem
>select emp_id,first name, city from employee, address where
>employee.emp_id=address.emp_id;
>this won't
>select e.emp_id,first name, city from employee e, address a where
>e.emp_id=a.emp_id;
>or
>select employee.emp_id,first name, city from employee, address where
>employee.emp_id=address.emp_id;
>Jim
>

Yes. Qualifying table names are something to watch. I will look into this possibility.

Thank you. Received on Sun Dec 06 1998 - 17:42:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US