Created
January 11, 2017 14:50
-
-
Save varpa89/9969301ff7d525bfc01a3b9edb77a90e to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
personlink0_.guid as guid1_99_, | |
personlink0_.createdTs as createdT2_99_, | |
personlink0_.updatedTs as updatedT3_99_, | |
personlink0_.provider_guid as provide10_99_, | |
personlink0_. timestamp as timestam4_99_, | |
personlink0_.child_guid as child_g11_99_, | |
personlink0_.link_create_date as link_cre5_99_, | |
personlink0_.deleted as deleted6_99_, | |
personlink0_.deleted_by_provider as deleted_7_99_, | |
personlink0_.link_end_date as link_end8_99_, | |
personlink0_.link_type as link_typ9_99_, | |
personlink0_.parent_guid as parent_12_99_ | |
from | |
person_link personlink0_ | |
left outer join person person1_ on personlink0_.parent_guid = person1_.guid | |
left outer join person person2_ on personlink0_.child_guid = person2_.guid | |
where | |
(person1_.guid is null) | |
and(person2_.guid is null) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment