> Thanks, that was a good explanation. One detail, though: I > didn't mention this before, but I have a linking table > because one of my relationships is many to many: > > Table: WordTypeLinking > Field 1: Word FK > Field 2: Type FK > > Does a linking table affect how things work, or can I just go > ahead and do an inner join between, in this case, with the 2 > tables where Word (PK) and Type (PK) are?
Yes, the linking table will affect how things work. You will need to INNER JOIN Word to WordTypeLinking, and INNER JOIN Type to WordTypeLinking within the same SQL statement. SELECT ... FROM Word INNER JOIN WordTypeLinking ON Word.WordID = WordTypeLinking.WordID INNER JOIN Type ON Type.TypeID = WordTypeLinking.TypeID Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194558 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
