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:[email protected]] Sent: Monday, January 12, 2009 8:15 AM To: [email protected] 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:[email protected] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] 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: [email protected] 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:[email protected] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: [email protected] 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: [email protected] 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.
