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

     1  // Code generated by TestPretty. DO NOT EDIT.
     2  // GENERATED FILE DO NOT EDIT
     3  1:
     4  -
     5  SELECT
     6  	phone0_.id AS id1_6_0_,
     7  	person1_.id AS id1_4_1_,
     8  	phone0_.phone_number
     9  		AS phone_nu2_6_0_,
    10  	phone0_.person_id AS person_i4_6_0_,
    11  	phone0_.phone_type
    12  		AS phone_ty3_6_0_,
    13  	addresses2_.person_id
    14  		AS person_i1_5_0__,
    15  	addresses2_.addresses
    16  		AS addresse2_5_0__,
    17  	addresses2_.addresses_key
    18  		AS addresse3_0__,
    19  	person1_.address AS address2_4_1_,
    20  	person1_.createdon
    21  		AS createdo3_4_1_,
    22  	person1_.name AS name4_4_1_,
    23  	person1_.nickname AS nickname5_4_1_,
    24  	person1_.version AS version6_4_1_,
    25  	addresses2_.person_id
    26  		AS person_i1_5_0__,
    27  	addresses2_.addresses
    28  		AS addresse2_5_0__,
    29  	addresses2_.addresses_key
    30  		AS addresse3_0__
    31  FROM
    32  	phone AS phone0_
    33  	INNER JOIN person AS person1_ ON
    34  			phone0_.person_id
    35  			= person1_.id
    36  	INNER JOIN person_addresses
    37  			AS addresses2_ ON
    38  			person1_.id
    39  			= addresses2_.person_id
    40  WHERE
    41  	EXISTS(
    42  		SELECT
    43  			calls3_.id
    44  		FROM
    45  			phone_call AS calls3_
    46  		WHERE
    47  			phone0_.id
    48  			= calls3_.phone_id
    49  	)
    50  
    51