|
| Subselect in SELECT SQL Query |
| Iniciado por windev, 26,may. 2015 16:28 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 26,mayo 2015 - 16:28 |
Hi,
with HFSQL SQL I tried to do something like this:
SELECT
pos.id
pos.artid
(SELECT art.NAME FROM article AS art WHERE art.id = pos.artid) AS artname
FROM
invoice_pos AS pos
It didn't work. Please don't tell me that it is not possible to use Subselects in the field part of an sql query.
Sebastian
--
http://arnoldconsult.de |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
123 mensajes |
|
| Publicado el 26,mayo 2015 - 20:34 |
HFSQL does not support Sub Select
--
Atte. Willian Fernando
Best Regards Willian Fernando |
| |
| |
| | | |
|
| | |
| |
| Publicado el 27,mayo 2015 - 10:39 |
Thanks Willian, but this is not completely true. Please see the docs for sub-select:
http://doc.pcsoft.fr/en-US/?2034009&name=Sub_query
From the docs:
A sub-query can be used:
as selection condition
as file of the main query
But anyway, this is defenitely a show stopper.
Sebastian |
| |
| |
| | | |
|
| | | | |
| | |
|