Re: Need help with SELECT 2 tables from choice of 3

2001-11-21 Thread Thomas S. Iversen
> OldMembers > Memebers > Data Why no have 3 tables: Members Data TheseMembersAreOld Members and Data are as you have them defined. TheseMembersAreOld contains only the Member_ID field. You then make the Member_ID field primary key on TheseMembersAreOld and Members. You can then perform a very

SCSI vs IDE

2001-11-20 Thread Thomas S. Iversen
Hi This is not an atempt to start a flamewar!! We're about to build a db server for educational purposes. Running 150+ databases pr. semester. Nothing big, nothing demanding when looking at a single database, but combined it may give some load (might be a lot of concurrent activity during class