Re: SQL error
- From: "John McKeon" <johnnymckeon+@+earthlink.net>
- Date: Thu, 25 Aug 2005 01:59:16 GMT
No answer huh?? I just posted an identical message. did you ever find the
cause of this problem? Think Ill check the DSN stettings......
"Man Utd" <alanpltseNOSPAM@xxxxxxxxxxxx> wrote in message
news:42d3182e$1@xxxxxxxxxxxxxxxxxxxxxxxxx
>I have this query:
> SELECT [IASSETS].IASSETID, [IASSETS].TITLE, [EDITIONS].DESCRIPTION,
> [EDITIONS].USERKEYWORDS, [DOCUMENTTYPES].DOCUMENTTYPEID AS
> CATID,
> [IASSETS].FILEPATH AS ACTUALDOCPATH, [IASSETS].ADDRESS AS
> ACTUALDOCNAME,
> [IASSETS].ISACTIVE, [PROCEDURETYPES].PROCEDURETYPEID AS
> SYSTEMID
> FROM [IASSETS]
> LEFT JOIN [EDITIONS] ON ([EDITIONS].IASSETID =
> [IASSETS].IASSETID) AND
>
> ([EDITIONS].EDITIONID = [IASSETS].CURRENTEDITIONID)
> LEFT JOIN [PROCEDURETYPES] ON
> [PROCEDURETYPES].PROCEDURETYPEID = [EDITIONS].PROCEDURETYPEID
> LEFT JOIN [DOCUMENTTYPES] ON [DOCUMENTTYPES].DOCUMENTTYPEID =
> [EDITIONS].DOCUMENTTYPEID
>
> I got an sql query problem: EOleException with message
> 'Syntax error(missing operator) in query expression:
>
> "([EDITIONS].IASSETID = [IASSETS].IASSETID) AND ([EDITIONS].EDITIONID =
> [IASSETS].CURRENTEDITIONID)
> LEFT JOIN [PROCEDURETYPES] ON [PROCEDURETYPES].PROCEDURETYPEID =
> [EDITIONS].PROCEDURETYPEID
> LEFT JOIN [DOCUMENTTYPES] ON [DOCUMENTTYPES].DOCUMENTTYPEID = ["
>
> Anyone knows what did I do something wrong?
>
>
.
- Follow-Ups:
- Re: SQL error
- From: Riki Wiki
- Re: SQL error
- Prev by Date: Re: Filter error... but why?
- Next by Date: Re: Populate dataset with text file
- Previous by thread: SQL syntax problem........
- Next by thread: Re: SQL error
- Index(es):
Relevant Pages
|
