Looking for a select command

[NJ88210]

Good Morning
I'm looking for a select command that will show schedules without any node associations. I see a select that will show nodes without schedules, I need the reverse.

 

[JonDoe]

Something like this combines both:
select c.domain_name,c.schedule_name,count(a.node_name) as NR from client_schedules c left join associations a on a.domain_name=c.domain_name and a.schedule_name=c.schedule_name group by c.domain_name,c.schedule_name order by NR desc

 

[marclant]

Something like this combines both:
select c.domain_name,c.schedule_name,count(a.node_name) as NR from client_schedules c left join associations a on a.domain_name=c.domain_name and a.schedule_name=c.schedule_name group by c.domain_name,c.schedule_name order by NR desc

Good job. I tried last week, but failed. I was trying to do a select within a select, but can't do it for 2 fields at a time. By doing a count like you did, it circumvented that.