Name them properly in the begining then you dont need to for example, i have a table called ForumTopisToForumCategories, indicating to me that its a joiner table between Forum Topics and Forum Categories
If you wanted to then make it short hand for your SQL you coulf alias to be FTTFC or something, but its rare. I only alias if i am joining a table onto its self -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Beattie Sent: Tuesday, May 03, 2005 3:32 PM To: CFAussie Mailing List Subject: [cfaussie] Re: [best practice or your practice] Specifying table names in queries when you're joining tables that have similar names. we have 700+ tables, most related tables have some prefix that's the same for all those tables (10+ tables for "post*" or "rpt*" or "sub*"...etc) my 2c barry.b > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark > Stanton > Sent: Tuesday, 3 May 2005 3:27 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: [best practice or your practice] Specifying > table names in queries > > > How do table aliases become clearer and less ambiguous than the table > names themselves? > -- > Mark Stanton > Gruden Pty Ltd > http://www.gruden.com > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
