Access中的多个LEFT JOIN [英] Multiple LEFT JOIN in Access

问题描述

我有以下查询，该查询适用于MySQL:

I have the following query, which works for MySQL:

DELETE `test1`, `test2`, `test3`, `test4` FROM
`test1` LEFT JOIN `test2` ON test2.qid = test1.id
LEFT JOIN test3 ON test3.tid = test2.id
LEFT JOIN test4.qid = test1.id
WHERE test1.id = {0}

但是它不适用于MS Access.我尝试在LEFT JOIN周围添加括号，但是它在FROM子句中给了我语法错误. 那么，该查询应如何显示才能在MS Access中工作?

But it doesn't work for MS Access. I've tried to add parentheses around the LEFT JOIN, but it gives me syntax error in FROM clause. So how should this query look in order to work in MS Access?

推荐答案

访问权限删除需要加星号(*):DELETE * FROM ...

The Access DELETE requires a star (*): DELETE * FROM ...

此外，必须使用括号将联接嵌套:

In addition, the joins must be nested by using parentheses:

DELETE test1.*, test2.*, test3.*, test4.*
FROM
    (
      (
        test1 
        LEFT JOIN test2 ON test1.qid = test2.id
      )
      LEFT JOIN test3 ON test2.tid = test3.id
    )
    LEFT JOIN test4 ON test1.qid = test4.id
WHERE test1.id = {0}

这篇关于Access中的多个LEFT JOIN的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！