hi all..
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.
table details
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