dicowins
ADSM.ORG Member
I have two sql statements
select domain_name,schedule_name,count(*) from associations group by domain_name,schedule_name
and
select domain_name,schedule_name,action,sched_style,starttime,period,perunits,duration,durunits,dayofweek,enh_month,dayofmonth,weekofmonth,expiration from client_schedules
So the first creates a unique list of Domeain names and schedules and calculates the No of nodes per schedule.
I want to then fill in the unique values selected in the second sql line and add those details to the first list
select domain_name,schedule_name,count(*) from associations group by domain_name,schedule_name
and
select domain_name,schedule_name,action,sched_style,starttime,period,perunits,duration,durunits,dayofweek,enh_month,dayofmonth,weekofmonth,expiration from client_schedules
So the first creates a unique list of Domeain names and schedules and calculates the No of nodes per schedule.
I want to then fill in the unique values selected in the second sql line and add those details to the first list