Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Please be aware that ADSM.ORG will be going through forum software conversion and migration over the next several weeks. The cut-over date and time will be posted in the ADSM.ORG News & Announcements section as we near the target date. Please visit the following link for more details ADSM News & Announcements
Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.
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.
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
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.