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
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
2 matches
Mail list logo