A2002 SP3中的奇怪问题 [英] Strange problems in A2002 SP3

问题描述

我正在尝试创建一个用作报表记录源的查询。下面是

我想做什么（这是经过测试并使用MySQL网页脚本）：


SELECT

联系人.id，

contacts.email，

contacts.first_name，

contacts.last_name，

contacts.middle_name ，

contacts.company，

contacts.address，

contacts.address2，

contacts.city，

contacts.state，

contacts.country，

contacts.zip，

contacts.phone，
contacts.website，

contacts.how_found，

contacts.specific_other，

contacts.comments，

contacts.submitted，

contacts.mail_list，

contacts.travel_dates，

interests.name

来自联系人，兴趣

LEFT JOIN idx_interest ON idx_interest.contact_id = contacts.id

WHERE idx_interest.interest_id = interests.id


要创建查询，我单击新查询按钮，选择设计

vi呃，切换到SQL视图，然后粘贴它。当我尝试保存

查询时，我得到一个JOIN操作中的语法错误。信息。当我点击

OK时，Access会突出显示联系人。 SELECT contacts.id的一部分。我是

使用Access 2002（10.6501.6626）SP3。


非常感谢任何帮助，


TIA


-

Justin Koivisto - sp ** @ koivi.com
http://www.koivi.com

I am trying to create a query to use as a report record source. Below is
what I want to do (this was tested and works with a MySQL web script):

SELECT
contacts.id,
contacts.email,
contacts.first_name,
contacts.last_name,
contacts.middle_name,
contacts.company,
contacts.address,
contacts.address2,
contacts.city,
contacts.state,
contacts.country,
contacts.zip,
contacts.phone,
contacts.website,
contacts.how_found,
contacts.specific_other,
contacts.comments,
contacts.submitted,
contacts.mail_list,
contacts.travel_dates,
interests.name
FROM contacts, interests
LEFT JOIN idx_interest ON idx_interest.contact_id = contacts.id
WHERE idx_interest.interest_id = interests.id

To create the query, I click on the new query button, select design
view, switch to SQL view, then paste this in. When I try to save the
query, I get a "Syntax error in JOIN operation" message. When I click
OK, Access highlights the "contacts" part of "SELECT contacts.id". I am
using Access 2002 (10.6501.6626) SP3.

Any help is greatly appreciated,

TIA

--
Justin Koivisto - sp**@koivi.com
http://www.koivi.com

推荐答案

2004年9月8日星期三22:01:59 GMT，Justin Koivisto< sp ** @ koivi.com>

写道：

On Wed, 08 Sep 2004 22:01:59 GMT, Justin Koivisto <sp**@koivi.com>
wrote:

我正在尝试创建一个用作报告记录源的查询。下面是我想要做的事情（这是经过测试并使用MySQL网页脚本）：

SELECT
contacts.id，
[...更多字段]

interests.name
FROM联系人，兴趣
LEFT JOIN idx_interest ON idx_interest.contact_id = contacts.id
WHERE idx_interest.interest_id = interests.id 查询时，我获得JOIN操作中的语法错误信息。当我点击
OK时，Access会突出显示联系人。 SELECT contacts.id的一部分。我正在使用Access 2002（10.6501.6626）SP3。

非常感谢任何帮助，

TIA

I am trying to create a query to use as a report record source. Below is
what I want to do (this was tested and works with a MySQL web script):

SELECT
contacts.id, [ ... more fields ]
interests.name
FROM contacts, interests
LEFT JOIN idx_interest ON idx_interest.contact_id = contacts.id
WHERE idx_interest.interest_id = interests.id

To create the query, I click on the new query button, select design
view, switch to SQL view, then paste this in. When I try to save the
query, I get a "Syntax error in JOIN operation" message. When I click
OK, Access highlights the "contacts" part of "SELECT contacts.id". I am
using Access 2002 (10.6501.6626) SP3.

Any help is greatly appreciated,

TIA

这与Access语法完全不同。这是我将如何尝试

这样做（航空代码，未经测试）：


SELECT

contacts.id，

< ...更多字段...>，

interests.name

来自联系人

LEFT JOIN兴趣ON contacts.id = interest。 id;


HTH

Matthias Kl？y

-
www.kcc.ch

" ; Justin Koivisto < SP ** @ koivi.com>在消息中写道

news：rj ***************** @ news7.onvoy.net ...

"Justin Koivisto" <sp**@koivi.com> wrote in message
news:rj*****************@news7.onvoy.net...

我是尝试创建用作报表记录源的查询。下面是我想要做的（这是经过测试并与MySQL网页脚本配合使用）：

SELECT
contacts.id，
contacts.email，
contacts.first_name，
contacts.last_name，
contacts.middle_name，
contacts.company，
contacts.address，
contacts.address2， contacts.city，
contacts.state，
contacts.country，
contacts.zip，
contacts.phone，
contacts.website，
联系人.how_found，
contacts.specific_other，
contacts.comments，
contacts.submitted，
contacts.mail_list，
contacts.travel_dates，
interests.name
FROM联系人，兴趣
LEFT JOIN idx_interest ON idx_interest.contact_id = contacts.id
WHERE idx_interest.interest_id = interests.id

要创建查询，我点击在新的查询按钮上，选择设计视图，切换到SQL视图，然后粘贴当我尝试保存
查询时，我得到一个JOIN操作中的语法错误。信息。当我点击
OK时，Access会突出显示联系人。 SELECT contacts.id的一部分。我正在使用Access 2002（10.6501.6626）SP3。

非常感谢任何帮助，

TIA

I am trying to create a query to use as a report record source. Below is
what I want to do (this was tested and works with a MySQL web script):

SELECT
contacts.id,
contacts.email,
contacts.first_name,
contacts.last_name,
contacts.middle_name,
contacts.company,
contacts.address,
contacts.address2,
contacts.city,
contacts.state,
contacts.country,
contacts.zip,
contacts.phone,
contacts.website,
contacts.how_found,
contacts.specific_other,
contacts.comments,
contacts.submitted,
contacts.mail_list,
contacts.travel_dates,
interests.name
FROM contacts, interests
LEFT JOIN idx_interest ON idx_interest.contact_id = contacts.id
WHERE idx_interest.interest_id = interests.id

To create the query, I click on the new query button, select design
view, switch to SQL view, then paste this in. When I try to save the
query, I get a "Syntax error in JOIN operation" message. When I click
OK, Access highlights the "contacts" part of "SELECT contacts.id". I am
using Access 2002 (10.6501.6626) SP3.

Any help is greatly appreciated,

TIA

这个新闻组适用于_Access Morons_而不是MySQL Morons。

This newsgroup is for _Access Morons_ not MySQL Morons.

Matthias Klaey写道：

Matthias Klaey wrote:

2004年9月8日星期三22:01:59 GMT ，Justin Koivisto< sp ** @ koivi.com>
写道：

On Wed, 08 Sep 2004 22:01:59 GMT, Justin Koivisto <sp**@koivi.com>
wrote:

我正在尝试创建一个用作报告记录源的查询。下面是我想要做的事情（这是经过测试并使用MySQL网页脚本）：

SELECT
contacts.id，

I am trying to create a query to use as a report record source. Below is
what I want to do (this was tested and works with a MySQL web script):

SELECT
contacts.id,

[...更多字段]

[ ... more fields ]

interests.name

interests.name

FROM contacts，interest

FROM contacts, interests

LEFT JOIN idx_interest ON idx_interest.contact_id = contacts.id
WHERE idx_interest.interest_id = interests.id

创建查询，我点击新的查询按钮，选择设计视图，切换到SQL视图，然后将其粘贴。当我尝试保存
查询时，我得到一个JOIN操作中的语法错误。信息。当我点击
OK时，Access会突出显示联系人。 SELECT contacts.id的一部分。我正在使用Access 2002（10.6501.6626）SP3。

非常感谢任何帮助，

TIA

LEFT JOIN idx_interest ON idx_interest.contact_id = contacts.id
WHERE idx_interest.interest_id = interests.id

To create the query, I click on the new query button, select design
view, switch to SQL view, then paste this in. When I try to save the
query, I get a "Syntax error in JOIN operation" message. When I click
OK, Access highlights the "contacts" part of "SELECT contacts.id". I am
using Access 2002 (10.6501.6626) SP3.

Any help is greatly appreciated,

TIA

这与Access语法完全不同。以下是我将如何尝试（空气代码，未经测试）：

SELECT
contacts.id，
< ...更多字段...>，
interests.name
来自联系人
LEFT JOIN兴趣ON contacts.id = interests.id;

This is quite different from Access syntax. Here is how I would try to
do it (air code, not tested):

SELECT
contacts.id,
< ...more fields ...>,
interests.name
FROM contacts
LEFT JOIN interests ON contacts.id = interests.id;

那是行不通的，contacts.id是一个人，interest.id是什么

他们可能对idx_insterst表感兴趣，保持
$ b之间的关系$ b这两个......下面是一个如何设置的快速示例：


表结构：

联系人

--------

id int

name varchar

email varchar


兴趣

---------

id int

名称varchar


idx_interest

------------

interest_id int

contact_id int


桌子数据

联系人

--------

1，justin，ju **** @ example .com

2，zach，za ** @ example.com

3，josh，jo ** @ example.com

4， jw，jw @ example.com

5，joe，jo * @ example.com

利息

---------

1，sql

2，php

3，设计

4，销售

5，打印

6，网页

7，应用程序


idx_interest

------------

1,1

1,2

1,3

$

2,1

2,6

3,3

3,5

3,6

4,4

4,5


我所追求的是：


+ --------------- ------------------------------ +

|名字|电子邮件|兴趣|

+ --------------------------------------- ------ +

| justin | ju****@example.com | sql |

+ --------------------------------------- ------ +

| justin | ju****@example.com | php |

+ --------------------------------------- ------ +

| justin | ju****@example.com |设计|

+ --------------------------------------- ------ +

| justin | ju****@example.com |网页|

+ --------------------------------------- ------ +

|扎克| za**@example.com | sql |

+ --------------------------------------- ------ +

|扎克| za**@example.com |网页|

+ --------------------------------------- ------ +

|乔什| jo**@example.com |设计|

+ --------------------------------------- ------ +

|乔什| jo**@example.com |打印|

+ --------------------------------------- ------ +

|乔什| jo**@example.com |网页|

+ --------------------------------------- ------ +

| jw | [e-mail] |销售|

+ --------------------------------------- ------ +

| jw | [e-mail] |打印|

+ --------------------------------------- ------ +


无论如何，对MySQL工作正常，只是想知道JOIN sytax错误

来自哪里......


-

Justin Koivisto - sp**@koivi.com
http://www.koivi.com

That wouldn''t work, contacts.id is a person, interests.id is something
they may be interested in the idx_insterst table holds relations between
the two... Below is a quick example of how it is set up:

TABLE STRUCTURES:
contacts
--------
id int
name varchar
email varchar

interests
---------
id int
name varchar

idx_interest
------------
interest_id int
contact_id int

TABLE DATA
contacts
--------
1,justin,ju****@example.com
2,zach,za**@example.com
3,josh,jo**@example.com
4,jw,[e-mail]
5,joe,jo*@example.com

interests
---------
1,sql
2,php
3,design
4,sales
5,print
6,web
7,applications

idx_interest
------------
1,1
1,2
1,3
1,6
2,1
2,6
3,3
3,5
3,6
4,4
4,5

What I am after is:

+---------------------------------------------+
| name | email | interest |
+---------------------------------------------+
| justin | ju****@example.com | sql |
+---------------------------------------------+
| justin | ju****@example.com | php |
+---------------------------------------------+
| justin | ju****@example.com | design |
+---------------------------------------------+
| justin | ju****@example.com | web |
+---------------------------------------------+
| zach | za**@example.com | sql |
+---------------------------------------------+
| zach | za**@example.com | web |
+---------------------------------------------+
| josh | jo**@example.com | design |
+---------------------------------------------+
| josh | jo**@example.com | print |
+---------------------------------------------+
| josh | jo**@example.com | web |
+---------------------------------------------+
| jw | [e-mail] | sales |
+---------------------------------------------+
| jw | [e-mail] | print |
+---------------------------------------------+

Anyway, works fine with MySQL, just wondering where the JOIN sytax error
comes from...

--
Justin Koivisto - sp**@koivi.com
http://www.koivi.com

这篇关于A2002 SP3中的奇怪问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！