If there is only one table in the query I don't use table names, but if there are two or more I always specify table names even if I don't have to. It just makes it easier to read.
Another pet hate of mine is aliasing for the sake for it (FROM tablename t1, tablename t2, etc..)- why add one more layer of abstraction? -- 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/
