Yes, I can do that, I'm just kind of whinging about it. It would be very useful to see these things in relationship matrices or the traceability window. I guess I could log a feature request.
On that same topic, it appears somewhat random as to when Classifier is null vs 0 (even the identical primitive type, like double, can be either 0 or null for Classifier). Have you stumbled across a logic to that in your database investigations, by any chance? Also, for some reason Classifier and objectId have different datatypes in SQL, so you have to do some casting to make it work.
Something like this shows me what I need:
select o.Name,o.Stereotype,att.* from
t_object o,
(select a.Object_ID,a.Name,a.Type,a.Classifier,c.Name
from t_attribute a
left outer join t_object c on Cstr(c.Object_ID) = a.Classifier) att
where o.Object_ID=att.Object_ID