1 (edited by admin0440 2018-07-29 04:20:57)

Topic: Ask for help with calculations.

The value of sql does not appear.


http://myvisualdatabase.com/forum/misc.php?action=pun_attachment&item=4465&download=0

Post's attachments

Attachment icon 555.jpg 260.47 kb, 77 downloads since 2018-07-29 

Re: Ask for help with calculations.

Hi,
I think the syntax for your calculated field should be
(
select sum(qty) from ininfo where prdinfo.id = ininfo.id_prdinfo)
)
Also, you don't need id_ininfo in the prdinfo table (I imagine it's just a one-way relationship).
Regards,
Derek.