question

Haren avatar image
Haren asked

Multiple queries

I have 4 tables, Product_Master, Opening_Stock, Issue_detail & Purchase_detail. I want to calculate opening stock like Opening_stock.Opening_Stock + Purchase_Detail.Receipt_Qty - Issue_detail.Issue_Qty and store it into Product_Master.AsOnStock for date less then the supplied one. PLease help me
sqlhomeworksub-query
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
Have you tried writing the query exactly the way you've outlined? SELECT the appropriate columns from the tables and add those columns together. It should be extremely straight forward.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.