Hey Tim -
No, you weren't too late. I ended up calling it a night last night before I
could figure it out, hoping that a little sleep would help. Well, thanks to
you it did! I was close but needed one more join in there. I will have to
study yours and figure it out exactly, as I have a few more others that will
be similar. Any good resources or tips that helped you?? :)
Thanks again!
Todd
-Original Message-
From: Furry, Tim [mailto:tim.fu...@lsi.com]
Sent: Monday, January 12, 2009 8:15 AM
To: wdvltalk@lists.wdvl.com
Subject: RE:[wdvltalk] Subject: SQL Join Help
Todd,
Try this:
select N.news_ID, G.group_ID, N.news_Title, G.group_Title
from news as N
inner join group_news as GN on N.news_ID = GN.newsID
inner join groups as G on GN.group_ID = G.group_ID
where G.group_ID = 25
order by N.news_Title
Hope it's not too late to save your brain. :-)
Tim
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To:
mailto:subscribe-wdvlt...@intm-dl.sparklist.com or
use the web interface
http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: t...@promisingsites.com
To unsubscribe send a blank email to
leave-50520709-163615.c65e63020f4e664bb366b6b920afc...@lists.wdvl.com
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.
The WDVL Discussion List from WDVL.COM
To Join wdvltalk, Send An Email To:
mailto:subscribe-wdvlt...@intm-dl.sparklist.com or
use the web interface http://e-newsletters.internet.com/discussionlists.html/
Send Your Posts To: wdvltalk@lists.wdvl.com
To change subscription settings, add a password or view the web interface:
http://intm-dl.sparklist.com/read/?forum=wdvltalk
http://www.wdvl.com ___
You are currently subscribed to wdvltalk as: arch...@jab.org
To unsubscribe send a blank email to
leave-50520991-230552.f22dcf5120bad5a91a87f69f1e923...@lists.wdvl.com
To unsubscribe via postal mail, please contact us at:
Jupitermedia Corp.
Attn: Discussion List Management
475 Park Avenue South
New York, NY 10016
Please include the email address which you have been contacted with.