Thread: MySQL syntax error and logic issue
View Single Post
  #2 (permalink)  
Old 05-12-2008, 11:40 AM
WingedPanther's Avatar   
WingedPanther WingedPanther is offline
Super Moderator
  
Join Date: Jul 2006
Age: 35
Posts: 2,050
Last Blog:
wxWidgets is NOT code ...
Rep Power: 24
WingedPanther is a jewel in the roughWingedPanther is a jewel in the roughWingedPanther is a jewel in the roughWingedPanther is a jewel in the rough
Default Re: MySQL syntax error and logic issue
The biggest problem I see is you have NO conditions on how friends f is associated with the other two tables in your join. You really need at least 2 ON conditions.
__________________
CodeCall Blog | CodeCall Wiki | Shareware | Linux Forum
Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Reply With Quote