> > So, why is it preferable to have different names for foreign and > primary > keys if the most succinct SQL can be generated from them having the > same > name?
Because if you have a lot of tables in yur db, DBIx::Recordset doesn't knows which tables to join, if a lot of tables contains the same field name. At least this is the reason why I choose this aproach. It could be an option to dectect fields with the same name, but please make it an option, so it doesn't break anything existing Gerald -------------------------------------------------------------- Gerald Richter ecos electronic communication services gmbh IT-Securitylösungen * dynamische Webapplikationen * Consulting Post: Tulpenstrasse 5 D-55276 Dienheim b. Mainz E-Mail: [EMAIL PROTECTED] Voice: +49 6133 939-122 WWW: http://www.ecos.de/ Fax: +49 6133 939-333 -------------------------------------------------------------- | | ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info | +------------------------------------------------------------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]