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: Still stuck on a left join
Date: Thu, 28 Jun 2001 15:51:07 -0400
Message-ID: <JMEEKPBGBOBMKNANAGILOEAMCDAA.anepon@verveinternet.com> (raw)

I've been stuck now on a left join for about two weeks. DB is MSaccess2K,
language is ASP. I'm learning php and PgSQL now, and will be migrating
everything soon. In the mean time. If anyone knows where I am going wrong,
please let me know.

Here is my current SQL query:
SELECT T.ID, T.employee, T.task, T.description, T.hours_used, T.f_date,
P.project_name, C.name
FROM  track AS T LEFT JOIN project AS P ON  (T.project=P.project_id)  LEFT
JOIN clients AS C ON (T.client=C.ID)
WHERE T.client LIKE '%MMColParam%'

Here is the error I get:[Microsoft][ODBC Microsoft Access Driver] Syntax
error (missing operator) in query expression '(T.project=P.project_id) LEFT
JOIN clients AS C ON (T.client=C.ID)'

My DB structure:

I have 5 tables: clients,project,tasks,track,users

rows are as follows:

clients.ID,clients.name
project.project_id,client_id,project_name
tasks.TaskID,tasks.Task_Name
track.ID,track.employee,track.client,track.project,track.task,track.descript
ion,track.hours_used,trck.f_date
users.c_username,users.c_password

Anyone know where I am going wrong?

Thanks,
Ari

~~~~~~~~~~~~~~~~~~~~~~~~~
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 (2+ messages)  latest in thread

Message-ID: <JMEEKPBGBOBMKNANAGILOEAMCDAA.anepon@verveinternet.com>
Permalink:  ../JMEEKPBGBOBMKNANAGILOEAMCDAA.anepon@verveinternet.com/
Also on:    postgresql.org/message-id/JMEEKPBGBOBMKNANAGILOEAMCDAA.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: Still stuck on a left join
  In-Reply-To: <JMEEKPBGBOBMKNANAGILOEAMCDAA.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