Thanks Tim - it did help me tremendously. Sorry I jinxed you though! :( Todd
-----Original Message----- From: Furry, Tim [mailto:[email protected]] Sent: Tuesday, January 13, 2009 8:29 AM To: [email protected] Subject: 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 working out SQL queries as part of web development. Yours is a typical many-to-many relationship using a join table (sometimes also called a bridge or link table) in the middle, so once you understand it you'll be able to apply it in many situations. If it makes you feel better, I've been banging my head on what should be a fairly straightforward query (a bit more complex than yours) on and off for 4 hours now; can't seem to get it to work using joins, it works okay if I specify a WHERE clause...basically mapping one Boolean field to two Boolean fields in different tables. Hope you got yours working. :) 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-50536499-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-50539249-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.
