OZONE Asylum
Forums
Server-Side Scripting - Oh my!
SQL query for two tables
This page's ID:
27998
Search
QuickChanges
Forums
FAQ
Archives
Register
Edit Post
Who can edit a post?
The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.
Your User Name:
Your Password:
Login Options:
Remember Me On This Computer
Your Text:
Insert Slimies »
Insert UBB Code »
Close
Last Tag
|
All Tags
UBB Help
Here is what I have for the database : [b]tasks[/b] [ulist] id (auto incremented) owner created [/ulist] [b]users[/b] [ulist] id (auto incremented) fullname email [/ulist] 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:\ [img]http://www.danasoft.com/sig/cprompt.jpg[/img] [small](Edited by [url=http://www.ozoneasylum.com/user/1079]CPrompt[/url] on 05-26-2006 17:53)[/small]
Loading...
Options:
Enable Slimies
Enable Linkwords
« Backwards
—
Onwards »
Maximum Security
OZONE
DHTML/Javascript
Server-Side Scripting - Oh my!
CSS - DOM - XHTML - XML - XSL - XSLT
Stupid Basic HTML
Visual Therapy
Photoshop
Photoshop Pong, Anyone?
***WARNING*** BIG SIG APPROACHING
Photography
3D Modelling & Rendering
Multimedia/Animation
Print Graphics
Holding Pens
Philosophy and other Silliness
Outpatient Counseling
Site reviews!
Mad Scientists' Laboratory
Getting to know the Grail