What is wrong with the following SQL syntax for using a subquery? SELECT staffNo, fName, lName, position FROM staff WHERE branchNo = (SELECT branchNo FROM branch WHERE street = 163 Main St);

Nothing is wrong with the statement

The subquery needs to be in brackets {} rather than in parenthesis ().

the field branchNo needs to be listed in the first Select clause also

The two tables (staff and branch) must be listed in both FROM clauses