How to display or query this?

[mcapon]

i think you just want:-

select s.itemno, i.itemname, s.itemid, s.qty
from structure s
inner join table1 i
   on s.itemno = i.itemno

yeah almost but,,,,, it show the item name of column1 it should be the item name of column 2 sir...

Thanks anyway.. But i need more little help