- - Code, Content, and Presentation
- -- Databases
- ---- JOIN does not outputs data from only one table
redhatlab - 3:19 am on May 30, 2011 (gmt 0)
Just a note: you are connected to 3 tables
Have you try LEFT or RIGHT OUTTER JOIN? If I remember correctly the inner join will fail if any of the table don't have a value for the joining key.
Thread source: http://www.webmasterworld.com/databases_sql_mysql/4316517.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com