Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Join statment WITH Where and Order By clauses


rocknbil - 3:33 pm on Jun 22, 2012 (gmt 0)


I don't know - bench test it. :-) My **guess** would be that your approach contains a nested select, and may traverse more rows because it's essentially two selects. The approach I suggested is certainly a little less complex in the coding part.


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4449196.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com