database related

Question

sir i have two table 

1. Inventory which have 3 column InvId,PartNo,Quantity.

2. ItemCreate which have 6 column ItemId,SubPartName,SubPart,Description,PartSize,MinimumQuantity. 

 

here PartNo=Description means both have same value ion both table

 or

minimum quantity have a limit for every row:

 

like minimum quantity for first row 10 or quantity is 9 then show in grid view

if minimum quantity is 10 or quantity is 11 then not show in gridview

 

so plz send query that how to solve this problem with example please help me...............

 

i have urgent requirement..........