I'm trying to generate a report for storage abusers, just three columns:

Client Name      Last Access         Total Storage


This is the SQL statement That comes close:

select distinct(nodes.node_name) as "Client Name",date(nodes.lastacc_time)
as "Last Access" ,auditocc.total_mb as "Total Storage" from nodes,auditocc
where auditocc.node_name in (select node_name from nodes where
domain_name='xxx ) order by 2

but column three is always wrong.

What do I need to do to make the proper join here?



Fred Johanson
ITSM Administrator
University of Chicago
773-702-8464