Topic: Sqlquery calculated field summation error
i have invoice table with calculated field that calculate amount multiple price to give total value and that for each customer
with this query "(select productP from products where invoices.id_products = products.id) * invoices.quantity "
i mad new table called dept where i want to show how much total invoice had one customer bought , but i get error with query
"select total from invoices where dept.id_invoices = invoices.id"
also made column settings formula = sum in tablegrid
i upload the error message