Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 12.2 \(3445.102.3\))
Subject: Re: Help on SQL query
From: Rob Sargent <robjsargent@gmail.com>
In-Reply-To: <87k1i1klp2.fsf@news-spur.riddles.org.uk>
Date: Fri, 15 Feb 2019 10:38:08 -0700
Cc: Ian Tan <iantan1268@gmail.com>,
 pgsql-sql@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <499C11DB-F3CF-4316-845A-19ABCAF52962@gmail.com>
References: 
 <CAAj7RQ-vF3kPaC7Y5csgjL75Bo=FotP6W=s2LsRhirVE78b4HQ@mail.gmail.com>
 <87k1i1klp2.fsf@news-spur.riddles.org.uk>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Precedence: bulk


> On Feb 15, 2019, at 10:28 AM, Andrew Gierth =
<andrew@tao11.riddles.org.uk> wrote:
>=20
>>>>>> "Ian" =3D=3D Ian Tan <iantan1268@gmail.com> writes:
>=20
> Ian> How do I write an SQL query so that the "name" text in car_parts
> Ian> are added to the bill_of_materials table, so that it looks like
> Ian> this:
>=20
> The only trick with this is that you need to join the car_parts table
> twice (once for parent and once for child), and to do that you need to
> give it different alias names:
>=20
> select bom.parent_id,
>       ppart.name as parent_name,
>       bom.child_id,
>       cpart.name as child_name
>  from bill_of_materials bom
>  join car_parts ppart on (ppart.id=3Dbom.parent_id)
>  join car_parts cpart on (cpart.id=3Dbom.child_id);
>=20
> --=20
> Andrew (irc:RhodiumToad)
>=20

Andrew, will you do my homework too?=