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
