Question on a select statement

From: <yong321_at_yahoo.com>
Date: Tue, 06 Jul 1999 18:30:19 GMT
Message-ID: <7lthvr$lfa$1@nnrp1.deja.com>

I want to look at some entries in sys.public_dependency view. But it contains columns object_id and referenced_object_id instead of object_name. I want to view them as names. This is my select statement:

select a.object_name,b.object_name
from sys.public_dependency c,all_objects a,all_objects b where c.object_id=a.object_id and c.referenced_object_id=b.object_id

It seems to show the result correctly. But I want to confirm with experts in this newsgroup. Thanks.

Yong
Email:yong321_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 06 1999 - 13:30:19 CDT