OZONE Asylum
Forums
Server-Side Scripting - Oh my!
sql question
This page's ID:
32053
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
Hi. I know the title is a BIT vague but who cares. Following situation: I have two tables groups and contacts_to_groups groups: id name contactst_to_groups contact_id group_id i want to querry the groups table but add an additional column, something like is within I have the id of the contact that i am cheking against so the result should be something like: id | name | iswithin 0 group1 false 1 group2 true 2 group3 true 4 group4 false any idea how i could achive this? (musst be purely in SQL no php java etc.)
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