Hi Everyone - I always get tripped up by the joins, and my brain is aching tonight. This is probably a very easy question for some, so I'm happy to help your ego if you can help me! :)
Table "news": (for news articles) - news_ID - news_Title Table "groups": (for group names) - group_ID - group_Title Table "group_news": (to save the news article and the corresponding group - can have more than one group per article) - group_ID - news_ID What I'm trying to do is find the news articles that are only for a certain group (such as group_ID "25") I've tried a few joins and am either getting an error, or not quite the right information. ANY help is appreciated!!! Thanks! Todd ____ 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-50514410-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.
