Run two differant queries in one table for two differant table - TechRepublic
General discussion
June 15, 2011 at 11:46 AM
pratikgosvami90

Run two differant queries in one table for two differant table

by pratikgosvami90 . Updated 15 years ago

I want to run some queries which can help me to get result:

I am new for sql

I have two different tables Item and ItemDynamic

In the Item table I have the columns ItemLookUpcode, ItemID and Total Quantity.

In the Item Dynamic table I have the columns ItemID (same as Item table) and Quantity, StoreID.

I want to result as in one table which can give me ItmLookupCode and Quantity (Item.Quantity – ItemDynamic.Qunatity)

I have tried some queries but not worked out please help me.

Thank you in advance.

This discussion is locked

All Comments