Topic awaiting preservation: SQL query for two tables (Page 1 of 1)

Here is what I have for the database :

tasks

id (auto incremented)

owner

created

users

id (auto incremented)

fullname

email

In the "tasks" table the owner field is the same as the id in the "users" table.

What I need to be able to do, is to query the tasks table and pull the fullname from the users table that matches the owner field from tasks and id from users.

Make sense?

Right now I can query the tasks table and pull the owner field but it is an integer. So I need to match that number to the ID field in the users table and then pull the fullname out to display.

Thanks in advance!

Later,

C:\



(Edited by CPrompt on 05-26-2006 17:53)

Select users.fullname from users where tasks.owner = users.id AND (other logic to get the right user)



.:[ Never resist a perfect moment ]:.

thanks bit, but I was actually doing about that same thing and your's and mine gave this error :

quote:

---

#1109 - Unknown table 'tasks' in where clause

---

I know the table is there because the program is working and I can query just that table

Later,

C:\

Can you show us exactly what the code was that you were using?

oh I did miss somethnig

Select users.fullname from users,tasks where tasks.owner = users.id AND (other logic to get the right user)

My SQL is actually a bit rusty.



.:[ Never resist a perfect moment ]:.

ah...that did the trick. Much appreciated guys!

Later,

C:\

the concept in question is known as a mysql->join by the way