SELECT on an ADSM sql server

[simanek]

occupancy table
node_name, physical_mb

nodes table
node_name, contact_info

what i want is a single combined table joined on the node_name of the node_name, contact_info, and sum(physical_mb). Yes, this sounds very easy. However, this is running on an adsm sql server which only 'kind-of' supports joins. I'm trying to find a way to fool it. If you have a method of doing this please post it, no matter how simple or how complex. I have attempted the following statements to no avail:

select occupancy.node_name, sum(occupancy.physical_mb), nodes.contact from occupancy, nodes where nodes.node_name=occupancy.node_name group by occupancy.node_name

select occupancy.node_name, sum(occupancy.physical_mb), nodes.contact from occupancy inner join nodes on nodes.node_name=occupancy.node_name group by occupancy.node_name

I greatly appreciate any help you could give me. Thanks. Mike
~~~~
simanek@uiuc.edu
"It's a Swingline!"
~~~~