access+ado如何实现full join功能,为什么提示"未指定错误"(15分)

是不是只有left/right join而没有full join
如何实现full join?

有啊！请看yntax SELECT [TRANSACTION transaction]
[DISTINCT | ALL]
{* | <val> [, <val> 匽}
[INTO :var [, :var 匽]
FROM <tableref> [, <tableref> 匽
[WHERE <search_condition>]
[GROUP BY col [COLLATE collation] [, col [COLLATE collation] 匽
[HAVING <search_condition>]
[UNION <select_expr> [ALL]]
[PLAN <plan_expr>]
[ORDER BY <order_list>]
[FOR UPDATE [OF col [, col 匽]];

<val> = {
col [<array_dim>] | :variable
| <constant> | <expr> | <function>
| udf ([<val> [, <val> 匽])
| NULL | USER | RDB$DB_KEY | ?
} [COLLATE collation] [AS alias]
<array_dim> = [[x:]y [, [x:]y 匽]
<constant> = num | 'string' | charsetname 'string'
<function> = COUNT (* | [ALL] <val> | DISTINCT <val&gt
| SUM ([ALL] <val> | DISTINCT <val&gt
| AVG ([ALL] <val> | DISTINCT <val&gt
| MAX ([ALL] <val> | DISTINCT <val&gt
| MIN ([ALL] <val> | DISTINCT <val&gt
| CAST (<val> AS <datatype&gt
| UPPER (<val&gt
| GEN_ID (generator, <val&gt

<tableref> = <joined_table> | table | view | procedure
[(<val> [, <val> 匽)] [alias]
<joined_table> = <tableref> <join_type> JOIN <tableref>
ON <search_condition> | (<joined_table&gt
<join_type> = [INNER] JOIN
| {LEFT | RIGHT | FULL } [OUTER]} JOIN

<search_condition> = <val> <operator> {<val> | (<select_one&gt}
| <val> [NOT] BETWEEN <val> AND <val>
| <val> [NOT] LIKE <val> [ESCAPE <val>]
| <val> [NOT] IN (<val> [, <val> 匽 | <select_list&gt
| <val> IS [NOT] NULL
| <val> {>= | <=}
| <val> [NOT] {= | < | >}
| {ALL | SOME | ANY} (<select_list&gt
| EXISTS (<select_expr&gt

| SINGULAR (<select_expr&gt
| <val> [NOT] CONTAINING <val>
| <val> [NOT] STARTING [WITH] <val>
| (<search_condition&gt
| NOT <search_condition>
| <search_condition> OR <search_condition>

| <search_condition> AND <search_condition>
<operator> = {= | < | > | <= | >= | !< | !> | <> | !=}
<plan_expr> =
[JOIN | [SORT] [MERGE]] ({<plan_item> | <plan_expr>}
[, {<plan_item> | <plan_expr>} 匽)

<plan_item> = {table | alias}

{NATURAL | INDEX (<index> [, <index> 匽)| ORDER <index>}
<order_list> =
{col | int} [COLLATE collation]
[ASC[ENDING] | DESC[ENDING]]
[, <order_list>

我用了就不行啊你看看我的语句:
select a.id,b.name from a full join b on a.id=b.id

我用的是access+ado啊,我查了access97的帮助就没有full join
我的程序用left join就可以通过但不符合我的要求

你就只接jion吧1