pcsoft.us.windevCopyright 2026, PC SOFT27 May 2015 10:39:20 Z26 May 2015 16:28:04 ZHi, with HFSQL SQL I tried to do something like this: [code:sql] SELECT pos.id pos.artid (SELECT art.name FROM article AS art WHERE art.id = pos.artid) AS artname FROM invoice_pos AS pos [/code] 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.de30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52311-subselect-select-sql-query/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)windevpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52311-subselect-select-sql-query-52328/read.awp27 May 2015 10:39:20 ZThanks Willian, but this is not completely true. Please see the docs for sub-select: http://doc.pcsoft.fr/en-US/?2034009&name…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52311-subselect-select-sql-query-52328/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52311-subselect-select-sql-query-52328/read.awpSubselect in SELECT SQL QueryWillian Fernandopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52311-subselect-select-sql-query-52320/read.awp26 May 2015 20:34:20 ZHFSQL does not support Sub Select -- Atte. Willian Fernando Best Regards Willian Fernandohttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52311-subselect-select-sql-query-52320/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/52311-subselect-select-sql-query-52320/read.awpSubselect in SELECT SQL Query