General Ledger Delete Unused Groups Query: Difference between revisions

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

Revision as of 00:01, 10 January 2017

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=245"