https://www.webmaster-forums.net/crss/node/1024593 en https://www.webmaster-forums.net/web-database-development/help-wsql-query-restructuring#comment-1150311 <p>Try specifiying an ON cluase...</p> <p>SELECT ... FROM posts LEFT JOIN users ON users.uid=posts.tid ...</p> Sun, 25 Apr 2004 04:20:10 +0000 Mark Hensler comment 1150311 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/help-wsql-query-restructuring#comment-1150280 <p>yeah. i don'tknow how to restructure the query so that it will work</p> Sat, 24 Apr 2004 19:00:10 +0000 m3rajk comment 1150280 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/help-wsql-query-restructuring#comment-1150238 <p>Okay, and you want a query that will work, then, is that it? I'm a little confused about what your question is.</p> Sat, 24 Apr 2004 03:31:49 +0000 Suzanne comment 1150238 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/help-wsql-query-restructuring#comment-1150234 <p>there is no tid in users. that's it's problem.</p> Sat, 24 Apr 2004 03:06:14 +0000 m3rajk comment 1150234 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/help-wsql-query-restructuring#comment-1150228 <p>Sooo, you have a column named "tid" in the users table? Wow is this ever a good example of why using sensible names helps people troubleshoot. fid,pid,tid?!</p> <p>forum_id == fid<br /> thread_id == tid<br /> post_id == pid</p> <p>So, does users.thread_id exist? If not, then it can't join on that, right?</p> Sat, 24 Apr 2004 00:44:19 +0000 Suzanne comment 1150228 at https://www.webmaster-forums.net