At 10:55 AM 2/14/05, Matthew Walker wrote: >What you're looking for is an inner join.
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? Thanks, Roberto Perez [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194518 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54