> Name them properly in the begining then you dont need to ahhhh... If only it was a perfect world and legacy systems didn't exist, there was world peace and I had just won lotto...
put it this way - If I was still teaching db design, I'd have no shortage of examples of what NOT to do... > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Steve > Onnis > Sent: Tuesday, 3 May 2005 4:43 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: [best practice or your practice] Specifying > table names in queries > > > 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/ > --- 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/
