I have actually, but like a trooper i just accept that its the way it is and work with it
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Antony Sideropoulos
Sent: Wednesday, May 04, 2005 9:25 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: [best practice or your practice] Specifying table names in queries

I take it you've never had to work with a db that you haven't designed yourself?
 
Lucky [EMAIL PROTECTED].
 
The horror stories I could tell you...

 
On 5/3/05, Steve Onnis <[EMAIL PROTECTED]> wrote:
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
--- 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/

Reply via email to