- - Code, Content, and Presentation
- -- Databases
- ---- Need help with a complex MySQL select statement
brotherhood_of_LAN - 9:14 pm on Dec 5, 2011 (gmt 0)
For reference plogger, you can actually join the same table onto itself, the "AS" allows you to have synonyms so the DB engine can understand which table instance you're referencing.
SELECT * FROM table AS t1 INNER JOIN table AS t2 ON t1.id = t2.id
Thread source: http://www.webmasterworld.com/databases_sql_mysql/4394475.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com