Loading

dataretrive

Shyja Abraham

15y2.5k

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
If the query got resolved, then mark the post that helped you as Answer.
0
Micke Blomqvist15y ago
select i.itemname, i.unit, b.qty, b.rate
from items i
inner join bills b
on i.itemid = b.itemid
where b.billno = @billno and i.itemcode = @itemcode

Just replace items with your items tablename and bills with your bills tablename and assign the values to the two variables @itemcode and @billno.
0