simple table or column alias question from noob

jmellicker

Let's say you had three tables:

tasks
task_id
task_owner (links to user_id in users table)
task_name

task logs
log_task_id (links to parent task_id in tasks table)
task_log_creator (links to user_id in users table)
task_log_desc

users
user_id
user_name

Now, all I want is a SELECT statement that gets the correct usernames for BOTH:

task_owner

AND

task_log_creator

so I can echo to screen.

I can get either one but not both!

Is this a column alias JOIN question? Forgive me, I am brand new to this. :bemused:

Here is an illustration of what I'm hoping for:

task_name #1 | task_owner
task_log_creator | task_log_desc (task_log #1)
task_log_creator | task_log_desc (task_log #2)
task_log_creator | task_log_desc (task_log #3)

task_name #2 | task_owner
task_log_creator | task_log_desc (task_log #1)
task_log_creator | task_log_desc (task_log #2)
task_log_creator | task_log_desc (task_log #3)

etc.

maxpup979

select t.task_name,t.task_owner,l.task_log_creator,l.task_log_desc from tasks t,task_logs l
WHERE
t.task_owner=l.task_log_creator
AND t.task_owner='$some_variable';

should give you the proper data I think.

jmellicker

Thank you so much for your quick reply.

I actually went a different way, with a popup menu where the "selected" attribute made sure the right person was showing- it came out very slick!

while ($row = mysql_fetch_assoc($usersresult)) {
if($row['user_id']==$row_logs['task_owner']) {

$usernamehtml .= "\t<option value=\"" . $row['user_id']
		. "\" onselect\"controlOther(" . $row['user_id']
		. ")\"[B]selected[/B]>" . $row['user_username']
		. "</option>";

} else {

$usernamehtml .= "\t<option value=\"" . $row['user_id']
		. "\" onselect\"controlOther(" . $row['user_id']
		. ")\">" . $row['user_username']
		. "</option>";

}
}

I don't know much about HTML, there seems to be more HTML code then is needed for a popup, but it works, so oh well!

This turned out well because by selecting a different person you could switch the task owner...

Anyway, thinks again for the help! 🙂