More on SMI joins

I first wrote: > > >For example, joining syslocks and syssessions using owner from syslocks > >and sid (session id) from syssessions would enable one to get a list of > >which users had which locks. Unfortunately, the join condition doesn't work. > >Why is that? > Then Tom DeMott replied... > I tried this using: > > select * from syslocks, syssessions > where syslocks.owner = syssessions.sid> > and it worked fine. What error message > are you getting? > > Tom DeMott Thanks for writing, Tom. I don't get an error message, I simply get no rows found. I know this to be in error though because I purposely go out and lock something, see that my sid is, say, 1074 and verify that there is a record in syslocks with an owner value of 1074, i.e. matching. My thought is that it doesn't work because: a) There's a bug. b) It won't work - something to do with the *virtualness* of the tables. c) A combination of (a) & (b). d) I'm finally brain dead. Thanks for any further thoughts / assistance, Scott -- Scott F. Ford, DBA / Unix SA | sford@wvus.org bps (Benefit Panel Services) | elroy.jpl.nasa.gov!wvus!sford 888 South Figueroa Street, Suite 1400 | Voice: (213) 489-2694 Los Angeles, CA. 90017 | FAX: (213) 489-7973 "...The bozone layer: shielding the rest of the solar system from the earth's harmful effects...."