>>>> 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=listsearcharchive@lassosoft.com
Aug 03
Rik Wasmus Re: Too many aliases
Aug 03, 2011; 12:46
Rik Wasmus
Re: Too many aliases
Aug 03
David Lerer RE: Too many aliases
Aug 03, 2011; 10:24
David Lerer
RE: Too many aliases
Aug 03
shawn wilson RE: Too many aliases
Aug 03, 2011; 11:43
shawn wilson
RE: Too many aliases
Aug 04
Hal?sz S?ndor Re: Too many aliases
Aug 04, 2011; 08:25
Hal?sz S?ndor
Re: Too many aliases
Aug 04
David Lerer RE: Too many aliases
Aug 04, 2011; 08:43
David Lerer
RE: Too many aliases
Aug 04
Jerry Schwartz RE: Too many aliases
Aug 04, 2011; 10:10
Jerry Schwartz
RE: Too many aliases
Aug 04
Mike Diehl Re: Too many aliases
Aug 04, 2011; 08:41
Mike Diehl
Re: Too many aliases
Aug 04
Johnny Withers Re: Too many aliases
Aug 04, 2011; 10:21
Johnny Withers
Re: Too many aliases
Aug 05
Hal?sz S?ndor Re: Too many aliases
Aug 05, 2011; 15:39
Hal?sz S?ndor
Re: Too many aliases
Aug 06
Johnny Withers Re: Too many aliases
Aug 06, 2011; 15:08
Johnny Withers
Re: Too many aliases
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!