Received: from smtp4ve.mailsrvcs.net (smtp4vepub.gte.net [206.46.170.25]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5SJmDa12594 for ; Thu, 28 Jun 2001 15:48:13 -0400 (EDT) (envelope-from anepon@verveinternet.com) Received: from [141.151.8.181] (adsl-141-151-8-181.bellatlantic.net [141.151.8.181]) by smtp4ve.mailsrvcs.net (8.9.1/8.9.1) with SMTP id TAA48268140 for ; Thu, 28 Jun 2001 19:48:04 GMT Reply-To: From: "Ari Nepon" To: "Pgsql-Sql" Subject: Still stuck on a left join Date: Thu, 28 Jun 2001 15:51:07 -0400 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Importance: Normal X-Archive-Number: 200106/458 X-Sequence-Number: 3761 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. -----------------------------------------------------------------------