Unknown column ".." in the field "list of fields"

Question

I made a simple join request, but always get this nasty error.
Inquiry:

SELECT 
    `verk.id`, `verk.date`, `verk.quant`, `verk.verid`, `verk.kunde`, `verk.gebracht`, `loginuser_aqa.name`, `loginuser_aqa.id`
FROM 
    `verk` 
FULL JOIN 
    `loginuser_aqa`
ON
    loginuser_aqa.id = verk.verid
WHERE
    verk.gebracht = 0
ORDER BY  verk.date;

Error:

Unknown column "verk.id" in the "list of fields"

Provided by demo on rekest:
http://rextester.com/HDTJAA39589

I already tried to leave " verk" from verk.id, but then I got another error:

id is ambiguous.

Answer 1

There are at least two problems in this request.

-, , .

`verk.id`   -- WRONG

`verk`.`id` -- CORRECT

, SQL , , .., . , , verk.id

verk.id     -- ALSO CORRECT

, . , " MySQL" , , .

, MySQL FULL JOIN. FULL SQL. , :

...
FROM 
    `verk` 
FULL JOIN 
    `loginuser_aqa`
ON ...

MySQL , :

...
FROM 
    `verk` AS `FULL`
JOIN 
    `loginuser_aqa`
ON ...

, AS SQL, FULL verk.

, , . verk.id, FULL.id. SQL, MySQL.

, FULL OUTER JOIN , JOIN, INNER JOIN. , , .

, MySQL FULL 2013 : https://bugs.mysql.com/bug.php?id=69858 , , "Affects me" .

FULL OUTER JOIN MySQL, . . : MySQL

Answer 2

backticks.

:

`table.col`

`table`.`col`

, MySQL FULL JOIN. , , , . , .

:

SELECT 
    v.`id`, v.`date`, v.`quant`, v.`verid`, v.`kunde`, v.`gebracht`, a.`name`, a.`id`
FROM 
    `verk` v
LEFT JOIN 
    `loginuser_aqa` a
ON
    a.`id` = v.`verid`
WHERE
    v.`gebracht` = 0
ORDER BY  v.`date`;