>>>> 2011/08/02 12:11 +0530, Adarsh Sharma >>>> select p.* from table A p, B q where p.id=q.id
or select p.* from table B q , A p where q.id=p.id <<<<<<<< Why do people constantly change table names for queries, although, as here, it gain them nothing? It often makes for less clarity (for which table is this an alias???). This I would write select A.* from A JOIN B USING (id) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org