Office中国论坛/Access中国论坛

标题: [求助]自联接查询的写法(来自access帮助) [打印本页]

作者: tz-chf 时间: 2005-9-29 16:11
标题: [求助]自联接查询的写法(来自access帮助)
SELECT

authors.au_fname,

authors.au_lname,

authors1.au_fname AS Expr2,

authors1.au_lname AS Expr3

FROM

authors

INNER JOIN

authors authors1

ON authors.city

= authors1.city

AND authors.au_id

< authors1.au_id

WHERE

authors.city = 'Berkeley'

and语句可以这样写在where外面吗？

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)