sqlplus query problem where table name = column name
From: <hebertm_at_my-deja.com>
Date: Tue, 28 Nov 2000 22:33:49 GMT
Message-ID: <901bsd$iou$1_at_nnrp1.deja.com>
Date: Tue, 28 Nov 2000 22:33:49 GMT
Message-ID: <901bsd$iou$1_at_nnrp1.deja.com>
[Quoted] I'm using the sqlplus client that comes with Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production", and I'm seeing an odd problem. I'm not that experienced with sql, I'm sure there's an easy way around this.
I'm trying to specify a field in the where clause, in which the table name and column name are equal, e.g. "where base_site.site_name = site_name.site_name". That query results in an "invalid column" error message, even though there indeed is a column called site_name in the table site_name.
Any idea how to get around this?
Thanks,
Marc
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Nov 28 2000 - 23:33:49 CET