Xailer & OZ Software

there is a problem when we use a subquery like below:
product -> id_prod, code, description
supplier -> id_prod, id_supplier
SELECT p.description,
(SELECT s.id_supplier
FROM supplier as s
WHERE s.id_supplier = p.id_supplier)
FROM product as p
it works from workbench but don't from xailer!!!!!

Roberto escribió el lun, 10 septiembre 2012 21:47there is a problem when we use a subquery like below:
product -> id_prod, code, description
supplier -> id_prod, id_supplier
SELECT p.description,
(SELECT s.id_supplier
FROM supplier as s
WHERE s.id_supplier = p.id_supplier)
FROM product as p
it works from workbench but don't from xailer!!!!!
Could you check if QueryArray() makes the job correctly. TIA.
Regards,