How to combine three tables using a Join?

[buterfly0707]

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

[ThatThatGuy]

@buterfly0707
May be i can help if you post your entire table structure

[eneyardi]

where you put this code? In a form then on current? on load?