[thelist] SQL Madness! Many-to-many selection
Anthony Baratta
Anthony at Baratta.com
Fri Aug 17 16:20:36 CDT 2001
At 02:11 PM 8/17/2001, you wrote:
>I find that creating an intermediate table that has a one to many
>relationship to each of the tables in the many to many relationship helps
>and will be quicker when processing the query. You can use triggers to
>automatically update the intermediate table when other actions are
>performed on the other tables.
Why not a "view" and not have to worry about triggers?
---
Anthony Baratta
President
Keyboard Jockeys
"Conformity is the refuge of the unimaginative."
More information about the thelist
mailing list