Member Avatar for Hassan_9

hello guys ,i need some help i have 2 tables in msql server 2008.

table InList:ItemId,Description,Qtyin....
table OutList:ItemId,description,QtyOut...

Now,i need to make a query to give me the available Qty of each item
The available Qty is the (Sum of Qtyin) - (Sum of QtyOut)
i need the query asap,any help????
Thank you

  • 2 Contributors
  • 1 Reply
  • 100 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

If you can do a join on the two tables then you can do the calculation in the query. Without knowing the structure of the tables (include a description of the fields - the tables must have a common field) I can't provide a query.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.