SQL_Select hell...

gistfile1.adb

Query := SQL_Select
     (Fields        =>
        Organization.Org_Id &
        Organization.Org_Name &
        Organization.Sip_Uri &
        Contactentity.Ce_Id &
        Contactentity.Ce_Name &
        Contactentity.Isperson &
        Tag.Tag_Id &
        Tag.Tag_Name,
      From          =>
        Left_Join 
          (Organization, 
           Left_Join 
             (Contactentity_Organization,
              Left_Join 
                (Contactentity,
                 Left_Join 
                   (Contactentity_Tag,
                    Tag,
                    Tag.Tag_Id = Contactentity_Tag.Tag_Id),
                 Contactentity.Ce_Id = Contactentity_Tag.Ce_Id),
              Contactentity.Ce_Id = Contactentity_Organization.Ce_Id),
           Organization.Org_Id = Contactentity_Organization.Org_Id),
      Where         => Organization.Org_Id = 1);