SQL事务-Sql错误

Question

我试图从多个表中获取信息，并试图通过内部联接来获取信息，尽管我的语法似乎是正确的，但我得到了一个有关Transact- Sql语句的错误。我读过关于案例陈述的文档，但需要澄清我做错了什么。任何帮助都是非常感谢的。提前谢谢你。

查询：

SELECT 
    person.Id, person.firstName, person.lastName, person.birthdate, 
    Gender.Gender, household.Id, family.Id
FROM 
    (((person
INNER JOIN 
    family ON persons.Id = family.Id)
INNER JOIN 
    household ON persons.Id = household.Id)
INNER JOIN 
    Gender ON persons.id = Gender.Id);

错误：

只能使用选择Transact-Sql语句。

Answer 1

在这种情况下，您必须删除所有括号：

SELECT 
person.Id, person.firstName, person.lastName, person.birthdate, 
Gender.Gender, household.Id, family.Id
FROM  person
INNER JOIN family ON persons.Id = family.Id
INNER JOIN household ON persons.Id = household.Id
INNER JOIN Gender ON persons.id = Gender.Id;

Answer 2

处于当前状态的查询正试图从派生表中进行选择。

只需删除括号以设置正确的联接即可。

    SELECT 
    person.Id, person.firstName, person.lastName, person.birthdate, 
    Gender.Gender, household.Id, family.Id
    FROM  person
    INNER JOIN family ON person.Id = family.Id
    INNER JOIN household ON person.Id = household.Id
    INNER JOIN Gender ON person.id = Gender.Id