Hy i think u only have to following
select name from pickupgroup where pkid not in (select distinct fkpickupgroup from pickupgrouplinemap) On 18. May 2021, 10:11 +0200, Matthew Collins <mcoll...@block.co.uk>, wrote: > Hi All, > > Can someone point me I right direction for a SQL query I can run to show me > all pickup groups with no directory number associated with them. > > I had a search and can find a command that will return all pickup groups with > their members. > > run sql select n.dnorpattern, n.description, pg.name as PickupName from > numplan n join pickupgrouplinemap pglm on n.pkid = pglm.fknumplan_line join > pickupgroup pg on pglm.fkpickupgroup = pg.pkid > > > I could work backwards from that output, but hoping someone has the knowledge > to just show pickup groups with no members. > > Thanks in advance. > > > > _______________________________________________ > cisco-voip mailing list > cisco-voip@puck.nether.net > https://puck.nether.net/mailman/listinfo/cisco-voip
_______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip
