troubleshooting Question

Not sure having problems getting this SQL Statement working

Avatar of stargateatlantis
stargateatlantis asked on
16 Comments2 Solutions473 ViewsLast Modified:
I am not sure but I get the following error

Unknown column 'tsk.taskid' in 'on clause'

Here is the SQL statement

SELECT *,count(requestID) as requestCount FROM tasks tsk,tasks_categories,tasks_gallery,measure,auth_user left outer join task_user_request tskr on tsk.taskid=tskr.task_id where measure_id=measureid and userID=id and catid=cat_id and photoid=photo_id AND tsk.taskid=tskr.task_id GROUP BY userID,url
Lee Wadwell
Project Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros