I've got two tables that I want to join on building and room. Right now I'm doing it on Building Name, but I was wondering if it would be better to have a column for the building number in each table and do the join on that instead. Is it better to join on numbers rather than strings? Does it only make a difference for huge database?
I know what my input will be to the DB so user error wouldn't offset it.
Thanks...
- Nic
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
