Nested Request

WININFO

Hello, I would like to make a nested query using editor, I can't find a concrete example to reproduce this query below:

SELECT soc.nom, pr.qte_stock_init, p.label, ( SELECT count(*) FROM table4 as cd left join table5 as c on c.rowid = cd.fk_commande left join table6 as cde on cd.rowid = cde.fk_object where cde.fk_statut = 2 ) as Statut FROM winwing.table1 as pr left join table2 as soc ON soc.rowid = pr.fk_soc left join table3 as p ON p.rowid = pr.fk_product

Thank's

Clément

WININFO

It's ok, sorry for the disturbance