Subject SQL SYNTAX From Mustansir Ghor <mustan31@hotmail.com> Date Sun, 18 Mar 2018 15:27:49 -0400 Newsgroups dbase.getting-started Dear All I have dbf table SUMMARY with item (c), qtyin (n), qtyout (n)  as fields. With have following command I am able to insert all  qtyin into the SUMMARY table INSERT INTO SUMMARY (ITEM, QTYIN) SELECT ITEM,SUM(QTY) FROM ARRIVALS GROUP BY ITEM Then for the same item record in the SUMMARY table I need to add qtyout  from SALES table. Please can anybody guide me what SQL syntax with which I shall be able to do this Best Regards Mustansir