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

[FunkyDexter]

I'm sorry but I don't know what that means. It's showing the name of the item, taken from the item table. Can you be clearer in what you're trying to achieve?

From looking at your posts I'm not sure I'm understanding your data structure properly. I assume the Item No in your structure table is a foreign key to the Item No in your Item table. Is that right? If not can you explain clearly how your two tables are related.

Also, you've now created 3 separate threads related to this query (actually one's about inserting rather than deleting but it's all part of the same discussion I think). Please could you not do that. It makes it hard pull together all the details of what you're asking and therefore hard to give you an answer. Generally we'd ask that you only create a single thread for a question and only create a second thread if you've got a question that's substantially different. Thanks.