pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ari Nepon <anepon@verveinternet.com>
To: Pgsql-Sql <pgsql-sql@postgresql.org>
Subject: Help with a double left join
Date: Wed, 20 Jun 2001 17:34:30 -0400
Message-ID: <JMEEKPBGBOBMKNANAGILMEIBCCAA.anepon@verveinternet.com> (raw)

I am trying to do a left join FROM [a table with two columns that have
foreign IDs] LEFT JOIN [two other tables, each has a unique ID].

I have the left join working where I join only two tables (not three):
<!--current SQL-->
SELECT track.ID, track.employee, track.client, track.task,
track.description, track.hours_used, track.f_date, project.project_name
FROM track LEFT JOIN project ON track.project=project.project_id
WHERE track.client LIKE '%MMColParam%'
<!--end-->

the two tables are track and project. Track is the left of the left join. It
holds the foreign keys. project (and later clients) are the columns with the
keys. I need to also left join clients ON track.client=client.ID.  Would
someone tell me how the SQL statement should be that allows me to do the two
left joins? Would it be:
<!--wishful thinking SQL-->
SELECT track.ID, track.employee, track.task, track.description,
track.hours_used, track.f_date, project.project_name, clients.name
FROM track LEFT JOIN project ON track.project=project.project_id AND LEFT
JOIN client ON track.client=clients.ID
WHERE track.client LIKE '%MMColParam%'
<!--end-->


'%MMColParam%' is just a variable used to hold a querystring variable in
case anyone was wondering.

Thanks,

Ari

(database is MS access. language is ASP. Whole thing will eventually be
redone in PostgreSQL and PHP, just as soon as I learn them:)
~~~~~~~~~~~~~~~~~~~~~~~~~
Ari Nepon
MRB Communications
4520 Wilde Street, Ste. 2
Philadelphia, PA 19127
p: 215.508.4920
f: 215.508.4590
http://www.mrbcomm.com

-----------------------------------------------------------------------
Sign up for our email list and receive free information about
topics of interest to nonprofit communications, marketing, and
community building professionals. Free resources, articles, tips.
Go to http://www.mrbcomm.com and use the Mailing List form.
-----------------------------------------------------------------------




view thread (4+ messages)  latest in thread

Message-ID: <JMEEKPBGBOBMKNANAGILMEIBCCAA.anepon@verveinternet.com>
Permalink:  ../JMEEKPBGBOBMKNANAGILMEIBCCAA.anepon@verveinternet.com/
Also on:    postgresql.org/message-id/JMEEKPBGBOBMKNANAGILMEIBCCAA.anepon@verveinternet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: anepon@verveinternet.com
  Subject: Re: Help with a double left join
  In-Reply-To: <JMEEKPBGBOBMKNANAGILMEIBCCAA.anepon@verveinternet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox