dataretrive

Question

i have 2 tables first contains itemiditemcodeitemnameunit. and the 2nd contains billnoitemidqtyratevalue . i want the values of itemnameunit from first table and qtyratevalue from 2nd table when we enter the values of billno. and itemcode.

Suthish Nair · Answer

If the query got resolved then mark the post that helped you as Answer.

Micke Blomquist · Answer

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.