I totally agree. I use Aliases all the time. Faster, simpler, and just as easy. I have no problems in deciphering the query.
-----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Friday, March 31, 2006 8:02 PM To: CF-Talk Subject: RE: Anything inherently wrong with this query? > Readability > > famGrp is obvious FG is not > clnt is obvious C is not > emp is obvious E is not > > OK...I'm done > > There is nothing "technically" wrong with using meaningless (or so > short they are meaningless) aliases, but it sure makes life simpler > ;-) The big difference here is that there's a specific section of the code which says which alias belongs to which table. Normally, when people use hard-to-understand variable names, no such section exists. Personally, I have no problem reading other peoples' one- or two-letter table aliases, and I write my SQL queries the same way. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236754 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
