i have 3 tables called itemMaster,ItemWh,whWiseItem(table names i took just for example). here i want to retrieve data from all the 3 tables.
itemMaster having details of Item means Code,Description,UOM etc.
ItemWh-items fro perticular store.
whWiseItem-also transactions for perticular store with item code
what i want is, i want to take items details from itemMaster and items for perticular store from both ItemWh and whWiseItem.
all the tables having ItemCode.
i know how to combine two tables using JOIN. but how can i combine 3 tables.
SELECT whWiseItem.ItemId,itemMaster.ItemDescription, itemMaster.UnitPrice, FROM whWiseItem inner join itemMaster on whWiseItem.ItemID=itemMaster.ItemId where WhseId='001'
i want to take items in ItemWh which are not in whWiseItem table. please help me to do this im really confuse.
thank you all