Table “Material” have column “SlNo” “ProductName”
Table “Total” Have column “SlNo” “ProductName” “RecieptTotal” "IssueTotal "“Balance”
SELECT “Material”.“ProductName” FROM “Material” group by “Material”.“ProductName”
Above sql statement works in Tool SQL but when Update added then gets error … Single value expected
update “Total” set “Total”.“ProductName” = SELECT “Material”.“ProductName” FROM “Material” group by
“Material”.“ProductName” . can u help me out
Using HSQLDB