[thelist] SQL Madness! Many-to-many selection

[Anthony Baratta]

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."