Re: Many to many relationship data

[Peter Brawley]

If it could be automated, the bridge table would always contain a cross-join of the two tables---ie it would have a row for every possible combination of table1.id and table2.id. But if this were these case, you would not need the bridge table at all---you would only have to write an unconditional join ...

select t1.id,t2 id FROM table1 t1 JOIN table2 t2;

So I don't understand your question.

PB