请问这样的sql查询在access数据库如何实现(50分)

B

bearonline

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-12

• #1

access数据库中有3个表，分别是user1，user2，user3。其中表user1含有'name,tel,no' 3个字段;user2含有'name,add,mob' 3个字段;user3含有'age,sex,no' 3个字段。
其中user1和user2中有相同名称的字段'name',user1和user3有相同的字段'no'，就是以这些字段作为两个表的关联，现在想用sql查询select 表user1的tel字段值，user2的add，mob字段值，user的age，sex字段值，条件
是表user1的name字段的值等于user2的name字段的值 且 表user3的no字段值等于user1的no字段的值。
请问这样的sql查询在access数据库如何实现

 

Y

YNTW

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-12

• #2

select user1.tel,user2.add,user2,mob,user3.age,user3.sex from user1,user2,user3
where user1.name=user2.name and user1.no=user3.no

 

M

myconan

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-12

• #3

select user1.tel,user2.add,user2.mob,user3.age,user3.sex
from user1,user2,user3
where user1.name = user2.name
AND user3.no = user1.no

 

F

flintsoft

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-12

• #4

SELECT user1.tel, user2.add, user2.mob, user3.sex, user3.age
FROM (user1 INNER JOIN user3 ON user1.[no] = user3.[no]) INNER JOIN user2
ON user1.name = user2.name;

 

L

linglingx

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-12

• #5

select a.tel,b.add,b.mob,c.age,c.sex
from user1 a,user2 b,user3 c
where a.name = b.name
AND c.no = a.no
首先是这样，如果你严格一点的话，希望区别连接方式！

 

B

bearonline

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-13

• #6

to flintsoft:
如果想在你上面的语句再加上条件 ‘no＝2001’，请问如何写？

 

F

flintsoft

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-13

• #7

SELECT [user1].[tel], [user2].[add], [user2].[mob], [user3].[sex], [user3].[age]
FROM (user1 INNER JOIN user3 ON [user1].[no]=[user3].[no]) INNER JOIN user2 ON [user1].[name]=[user2].[name]
where user1.no=2001;

 

B

bearonline

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-13

• #8

to flintsoft:
如果是多个表关联是不是应该这样写：
SELECT user1.tel, user2.add, user2.mob, user3.sex, user3.age，user4.city,user5.con
FROM (((user1 INNER JOIN user3 ON user1.[no] = user3.[no]) INNER JOIN user2
ON user1.name = user2.name) INNER JOIN user4 ON user1.city = user4.city) INNER JOIN user5 ON user1.con = user5.con where user1.no=2001;

 

B

bearonline

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-13

• #9

top