ihoka (owner)

Revisions

gist: 225909 Download_button fork
public
Public Clone URL: git://gist.github.com/225909.git
Embed All Files: show embed
SQL #
raw 
1
2
3
4
5
6

select * from objectives where company_id = 2
union
select * from objectives 
	where (concat(coalesce(area_group, '-'), '|', key_result) not in
		(select concat(coalesce(area_group, '-'), '|', key_result) from objectives where company_id = 2))
	and (company_id is null)