elsedik قام بنشر يونيو 22, 2012 قام بنشر يونيو 22, 2012 برجاء شرح جملة Sql فى احدى امثلة الاستاذة الفاضلة ام عهود SELECT NewTable.ID, NewTable.CustomerID, NewTable.Date, NewTable.NUM, NewTable.[iN], NewTable.OUT, (select(sum([iN])-sum([OUT])) from [RASEEDB] where newtable.[iD]>=[iD] and NewTable.[CustomerID]= [CustomerID] ) AS TRASEED FROM RASEEDB AS NewTable WHERE (((NewTable.CustomerID)=[forms]![bank]![CusName])) ORDER BY NewTable.ID, NewTable.Date مرفق الملف zaBalance.rar
الردود الموصى بها
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.