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

  • Registered: 2018-07-29
  • Posts: 1

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, 242 downloads since 2018-07-29 

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

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.