General Ledger Delete Unused Groups Query: Difference between revisions

From KeystoneIntranet
Jump to navigation Jump to search
Intra>User
m (1 revision imported)
 
m (1 revision imported)
 
(No difference)

Latest revision as of 12:58, 14 July 2023

Preview with select query: 

Select * from gltacgrp g
 where not exists
    ( select * from gltacct a where a.gl_group = g.group_id)
  and not exists
    ( select * from gltacgrp g2 where g2.parent_group_id = g.group_id)



DELETE from gltacgrp g
 where not exists
    ( select * from gltacct a where a.gl_group = g.group_id)
  and not exists
    ( select * from gltacgrp g2 where g2.parent_group_id = g.group_id)
Retrieved from "http://in.compucrete.com/index.php?title=General_Ledger_Delete_Unused_Groups_Query&oldid=246"