Access SQL

Report · Nov 06, 2007

Hi,

Whats wrong with this SQL statement?

SELECT * FROM Main_tbl, Contact_tbl, AdminComments_tbl Left Join
AdminComments_tbl ON Main_tbl.ID=AdminComments_tbl.Maintblid WHERE
(Main_tbl.CompanyID = Contact_tbl.AutoID)

I keep getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.

Thanks!

Report · Nov 07, 2007

> Whats wrong with this SQL statement?

Just about everything!

You really need to think about what you are trying to achieve with your
SELECT and then form your query with consideration and thought. You have
errors just about everywhere in your current statement.

Pat.

"MM User" <mmuser@microsoft.com> wrote in message
news:fgqugg$eko$1@forums.macromedia.com...
> Hi,
>
> Whats wrong with this SQL statement?
>
> SELECT * FROM Main_tbl, Contact_tbl, AdminComments_tbl Left Join
> AdminComments_tbl ON Main_tbl.ID=AdminComments_tbl.Maintblid WHERE
> (Main_tbl.CompanyID = Contact_tbl.AutoID)
>
>
> I keep getting the following error:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.
>
>
> Thanks!

Report · Nov 10, 2007

Hi Pat,

From your reply - maybe I need to be specific about the Select statment and
only list which variables I need?

Thanks

"Pat Shaw" <pat@nomail.com> wrote in message
news:fgrvc9$pom$1@forums.macromedia.com...
>> Whats wrong with this SQL statement?
>
> Just about everything!
>
> You really need to think about what you are trying to achieve with your
> SELECT and then form your query with consideration and thought. You have
> errors just about everywhere in your current statement.
>
> Pat.
>
>
> "MM User" <mmuser@microsoft.com> wrote in message
> news:fgqugg$eko$1@forums.macromedia.com...
>> Hi,
>>
>> Whats wrong with this SQL statement?
>>
>> SELECT * FROM Main_tbl, Contact_tbl, AdminComments_tbl Left Join
>> AdminComments_tbl ON Main_tbl.ID=AdminComments_tbl.Maintblid WHERE
>> (Main_tbl.CompanyID = Contact_tbl.AutoID)
>>
>>
>> I keep getting the following error:
>>
>> Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>>
>> [Microsoft][ODBC Microsoft Access Driver] Syntax error in JOIN operation.
>>
>>
>> Thanks!
>
>