Access 支持三表或三表以上的 join 操作,但是要加括号,一层一层 JOIN 下去
例子:
1、SELECT * from XXas a left outer join YY as b
2、SELECT * from (XXas a left outer join YY as b
3、SELECT * into all_ from ((((XX as a left outer join YY as b
2021-10-04 05:04:22
Access 支持三表或三表以上的 join 操作,但是要加括号,一层一层 JOIN 下去
例子:
1、SELECT * from XXas a left outer join YY as b
2、SELECT * from (XXas a left outer join YY as b
3、SELECT * into all_ from ((((XX as a left outer join YY as b