Re: Join and Performance Question

2004-09-16 Thread gerald_clark
Ronan Lucio wrote: Hi, Supposing we have for tables: One master table (student) and three independent tables. There is no relationship between them. Each of the three table have a relationship with table student. City | Teacher | TestLocal | === | = city_id | teac_

Join and Performance Question

2004-09-16 Thread Ronan Lucio
Hi, Supposing we have for tables: One master table (student) and three independent tables. There is no relationship between them. Each of the three table have a relationship with table student. City | Teacher | TestLocal | === | = city_id | teac_id | test_id cit