Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
dependent join on first table field
I'm running mysql 4. I guess I could do that. But since a user can only be of one type, it's a waste to have to join all three types. Anyway, what you guys suggest works and I'll stick to that for now. Thanx a lot for your comments. -
dependent join on first table field
Well, I wish I didn't have to join all tables. I have four different user types and each has close to 20 fields. Joining all the tables would probably be slower than just the one needed. -
dependent join on first table field
Hello all, I hope someone can help me with this one. I have a user system that handles different user types. My main table is users_login which has their log in info plus the user type, and then I have users_typeA, users_typeB, users_typeC... to hold the info particular to that user type. I...
