hello, reading the documentation I'm confused to as which is better:
SELECT * FROM T1,T2 where T1.K1 = T2.K2 AND T1.K2=T2.K2 AND ...otherconditions... or should I do SELECT * FROM T1 NATURAL JOIN T2 WHERE ..other conditions.. or should I SELECT * FROM T1 JOIN T2 USING (K1,K2) WHERE ..other conditions... thanks, Singer -- Singer X.J. Wang, Ph.D. Candidate Faculty of Computer Science, Dalhousie University 6050 University Avenue, Halifax, NS, Canada, B3H 1W5 Email: [EMAIL PROTECTED] Fax: (902) 492-1517 WWW: http://www.singerwang.com Schedule: http://schedule.singerwang.com ------------------------------------------------------------------------------ Your reading of this email is contributing to the eventual heat death of the universe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]