dataretrive

Question

i have 2 tables  first contains itemid,itemcode,itemname,unit.

and the 2nd contains billno,itemid,qty,rate,value .

i want the values of itemname,unit from first table and qty,rate,value from 2nd table when we enter the values of billno. and itemcode.