Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need To Dummy-Down Oracle
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