[SQL] Help with a double left join

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.5

RE: [SQL] Help with a double left join

LEFT JOIN client ON track.client=clients.ID WHERE track.client LIKE '%MMColParam%' Any thoughts? Thanks in advance. (see below for explanation of my DB structure if you would like). Ari -Original Message- From: Alex Pilosov [mailto:[EMAIL PROTECTED]] Sent: Friday, June 22,

[SQL] Still stuck on a left join

askID,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, S

[SQL] You have an error in your SQL syntax near '' at line 1

OIN tbl_task ON tbl_all.task_ID=tbl_task.task_name"; $where="WHERE tbl_all.client_ID = $clients"; $all_query ="SELECT $columns_to_select FROM tbl_all $left_join $left_join2 $where"; Thanks, Ari ~ Ari Nepon MRB Communications 4520 Wilde