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.