-- E.Gallas Oct 2005
--
-- how many trigger lists have no triggers?
--------------------------------------------
select tl.tl_name,tl.tl_version 
	from trigger_lists tl, tl_maps tlm
	where tl.tl_name = tlm.tl_name 
	and   tl.tl_version = tlm.tl_version 
	and not exists
	(select tl_name,tl_version 
	from tl_maps)
	;
-- none found

select unique tl.tl_name,tl.tl_version 
	from trigger_lists tl, tl_maps tlm
	where tl.tl_name = tlm.tl_name 
	and   tl.tl_version = tlm.tl_version 
	and exists
	(select unique tl_name,tl_version 
	from tl_maps)
	;
-- 398 rows selected.


select tl.tl_name,tl.tl_version 
	from trigger_lists tl
	;
-- 398 rows selected.

