github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/4.sql (about)

     1  select
     2          phone0_.id as id1_6_0_,
     3          person1_.id as id1_4_1_,
     4          phone0_.phone_number as phone_nu2_6_0_,
     5          phone0_.person_id as person_i4_6_0_,
     6          phone0_.phone_type as phone_ty3_6_0_,
     7          addresses2_.Person_id as Person_i1_5_0__,
     8          addresses2_.addresses as addresse2_5_0__,
     9          addresses2_.addresses_KEY as addresse3_0__,
    10          person1_.address as address2_4_1_,
    11          person1_.createdOn as createdO3_4_1_,
    12          person1_.name as name4_4_1_,
    13          person1_.nickName as nickName5_4_1_,
    14          person1_.version as version6_4_1_,
    15          addresses2_.Person_id as Person_i1_5_0__,
    16          addresses2_.addresses as addresse2_5_0__,
    17          addresses2_.addresses_KEY as addresse3_0__ 
    18      from
    19          Phone phone0_ 
    20      inner join
    21          Person person1_ 
    22              on phone0_.person_id=person1_.id 
    23      inner join
    24          Person_addresses addresses2_ 
    25              on person1_.id=addresses2_.Person_id 
    26  where
    27          exists (
    28              select
    29                  calls3_.id 
    30              from
    31                  phone_call calls3_ 
    32              where
    33                  phone0_.id=calls3_.phone_id
    34          )