Ok, so I updated the statement like the past few posts have directed so the statement looks like this:
SELECT FORUMCAT1.LASTPOST, USERS.USERNAME, FORUMCAT1.ID, FORUMCAT1.TOPIC, FORUMCAT1.REPLIES, FORUMCAT1.ORIGINATOR, FORUMCAT1.STATUS FROM USERS INNER JOIN (FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER) ON USERS.ID = FORUMMSG1.AUTHORID WHERE ((FORUMCAT1.STATUS !=2) AND (FORUMMSG1.MESSAGE Like "%java%")) ORDER BY FORUMCAT1.LASTPOST DESC; And this is the message that I get: You have an error in your SQL sytax near '(FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = FORUMMSG1.POSTNUMBER)ON USERS' at line 1. Thanks, Mat ----- Original Message ----- From: "Nathan" <[EMAIL PROTECTED]> To: "Mat Murdock" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 12:03 PM Subject: Re: How to rewrite this statement. > Where does mysql say there is a problem? By the by, your WHERE clause should read thusly: > > WHERE FORUMCAT1.STATUS != 2 AND FORUMMSG1.MESSAGE LIKE "%java%" > > MySQL does not use <> for not equal to AFAIK, and you don't need to enclose the clauses in parens. > Also, the wildcards for LIKE are % for * and _ for ? if you get my meaning ;-) > > Let us know what the error is. > > # Nathan > > ----- Original Message ----- > From: "Mat Murdock" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, February 22, 2002 11:51 AM > Subject: How to rewrite this statement. > > > I have this query that works just fine in msacess agains some linked mysql > tables, but if I run this statement in php or in mysqlfront it doesn't work. > I belive it's because there is two joins in it but i'm not sure. If that is > the problem then what is the work around? Here is the statement: > > SELECT FORUMCAT1.LASTPOST, USERS.USERNAME, FORUMCAT1.ID, FORUMCAT1.TOPIC, > FORUMCAT1.REPLIES, FORUMCAT1.ORIGINATOR, FORUMCAT1.STATUS > FROM USERS INNER JOIN (FORUMCAT1 INNER JOIN FORUMMSG1 ON FORUMCAT1.ID = > FORUMMSG1.POSTNUMBER) ON USERS.ID = FORUMMSG1.AUTHORID > WHERE (((FORUMCAT1.STATUS)<>2) AND ((FORUMMSG1.MESSAGE) Like "*java*")) > ORDER BY FORUMCAT1.LASTPOST DESC; > > Thanks ahead of time! > > Mat > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
