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: arch...@jab.org To unsubscribe send a blank email to leave-50520709-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.