Re: OT: Link Tables Vs. Joins

2002-03-19 Thread Hatton Humphrey
You're talkeing about two different things here. A link table is a way to create a many-to-many association when you have only one record on the two associated tables. A join is a way to connect data in a query based on common columns. Here's a scenario where I'd use a link table: Customers

OT: Link Tables Vs. Joins

2002-03-19 Thread savan . thongvanh
Do you guys/gals use link tables? how much benefit do you really get from using them? I'm working w/ a developer that seems to want to use a link table for every little thing. I understand that they help reduce the amount of data that's repeated but are they worth it? I've ignored link tables