> 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:236753 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
