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/
