age -----
> 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
>
: How to rewrite this statement.
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
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.
From: Mat Murdock <[EMAIL PROTECTED]>
> ... Like "*java*"
Try:
Like "%java%"
I would bet the the aseriscs are some non-SQL extention of MS Access.
---
Rodney Broom
Programmer: Desert.Net
-
Before posting, please check:
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:
SE