RE:[wdvltalk] Subject: SQL Join Help

Todd wrote... 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! Tim responds... You're quite welcome. :) No particular resources were used other than the few years I have

RE: [wdvltalk] Subject: SQL Join Help

Thanks Tim - it did help me tremendously. Sorry I jinxed you though! :( Todd -Original Message- From: Furry, Tim [mailto:tim.fu...@lsi.com] Sent: Tuesday, January 13, 2009 8:29 AM To: wdvltalk@lists.wdvl.com Subject: RE:[wdvltalk] Subject: SQL Join Help Todd wrote... I will have

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

RE: [wdvltalk] Subject: SQL Join Help

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