Hi guys,

I have typed this query, which works fine, but I need to be able to do
more.  First off here is the select command :

select distinct entity as Node, activity as Activity, start_time
as Start, end_time as End, affected as Files_Backed_up, bytes as
Total_Bytes fro
m summary where activity = 'BACKUP'

What I would like to do is also group this by the entity so that I
basically only receive one instance of the node.  Plus I would like to be
able to select only the information that pertains to current day - 1
(yesterday).

If anyone has any ideas I would love to hear them.  I have tried to add the
group by entity after the where statement but it tells me that I cannot
have the activity, start_time, end_time, affected and bytes columns in the
query unless I place them within an aggregate function.

Thank you,

Yanki Yuksel
_____________________________
Yanki Yuksel
Sr. Systems/Network Administrator
Alcatel Canada
1235 Ormont Drive
Weston, Ontario, Canada
M9L 2W6
Tel:  (416) 742-3900 ext 5767
Fax: (416) 742-9088
e-mail : Yanki.Yuksel AT tas.alcatel DOT ca
_____________________________