|
| [WD20] Parameter for SubQuery |
| Iniciado por guest, 25,ene. 2016 15:31 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 25,enero 2016 - 15:31 |
Hi,
I created a Query in the editor (see below). How can I pass the parameter for the Subquery or is that impossible in the editor ?
SELECT
Nutzer.GUID AS GUID,
Nutzer.Name AS Name,
Nutzer.Firma AS Firma,
Nutzer.Emailadresse AS Emailadresse
FROM
Nutzer
WHERE
Nutzer.GUID NOT IN
(
SELECT
Projekte_Nutzer.Nutzer_GUID AS Nutzer_GUID
FROM
Projekte_Nutzer
WHERE
Projekte_Nutzer.Projekt_GUID = {ParaPROJEKT_GUID}
AND Projekte_Nutzer.Geloescht = {ParaGELOESCHT}
)
ORDER BY
Name ASC |
| |
| |
| | | |
|
| | | | |
| | |
|