troubleshooting Question

Not sure having problems getting this SQL Statement working

Avatar of stargateatlantis
stargateatlantis asked on
MySQL ServerSQL
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
ASKER CERTIFIED SOLUTION
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