[EMAIL PROTECTED]: > Ok, I trying to get this example... what is "table1 t1, table2 t2, > table3 t3, table4 t4", I mean, what does the t1, t2, t3, t4 represent? > If you say, table 1, table 2, etc.... well, I assume that, but isn't > that there already?
t1, t2 etc represents an alias for the table. If you have a long tablename, you can give it a short alias, and then just use the short alias in the rest of the query. ---- Peter Rønning -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]