how this query works?

[phpsharma]

Hi all,

I have a difficult time in understanding this query. please any one here to help me.

SELECT tasks.task_id, task_parent, task_name, task_start_date, task_end_date, task_priority, task_percent_complete, task_duration, task_duration_type, task_project, task_description, task_owner, user_username, task_milestone FROM tasks, user_tasks
LEFT JOIN projects ON project_id = task_project
LEFT JOIN users as usernames ON task_owner = usernames.user_id
WHERE project_active != 0 AND task_project = projects.project_id AND user_tasks.user_id = 24 AND user_tasks.task_id = tasks.task_id AND task_status = '0' AND ( (1=1) )
ORDER BY project_id, task_name, task_start_date

sharma

[rachel2004]

It is better to append the table name to the column name when working with multiple tables:

SELECT table1.column1,
table1.column2,
table2.column1
etc.

As far as your question, it appears that a LEFT JOIN is being used to "join" tables based on some common criteria specified in the WHERE clause. Aside from that info, I'm not sure what more you need an explanation on.