database related

Question

sir i have two table 1. Inventory which have 3 column InvIdPartNoQuantity. 2. ItemCreate which have 6 column ItemIdSubPartNameSubPartDescriptionPartSizeMinimumQuantity. 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..........

Raja T · Answer

Dear Jitendra I have given the condition in that query like  where minimumquantity >= quantity This is to check minimumquantity is greater than or equal to quantity and it will select the reords which satisfies this condition. Thanks

Jitendra Sharma · Answer

thanks for this sir problem is that how to compare minimum quantity or quantity ..... this query only for select single value or single row...

Raja T · Answer

Dear Jitendra I am not able to see the image of your table. Anyways plz execute the below query and send me what error you are getting then only i can identify the bug in my query and help you. Kindly execute this query: select a.InvIda.PartNoa.Quantityb.ItemIdb.SubPartNameb.SubPart b.Descriptionb.PartSizeb.MinimumQuantity from Inventory a join ItemCreate b on a.PartNo=b.Description where minimumquantity Thanks :-)

Jitendra Sharma · Answer

this is my Inventory table see Both table images and find out that only selected those rows which is greater then or equal to quantity ...plz do something ...

Jitendra Sharma · Answer

hi sir  this is my ItemCreate Table ...

Raja T · Answer

Hi Jitendra There is no use/need of sharing this create table query here. Please execute the query which i have shared to you and please share what result or error u are getting. Thanks... :)

Raja T · Answer

For your requirement you just change the query like select a.InvIda.PartNoa.Quantityb.ItemIdb.SubPartNameb.SubPartb.Descriptionb.PartSizeb.MinimumQuantity from Inventory a join ItemCreate b on a.PartNo=b.Description where minimumquantity Here a.ItemId='1' --> filtering column 'ItemId' from table Inventory having value '1' b.PartSize='10' --> filtering column 'PartSize' from table ItemCreate having value '10' Plz let me know if u hav further doubts. Thanks

Raja T · Answer

Hi Try this query select a.InvIda.PartNoa.Quantityb.ItemIdb.SubPartNameb.SubPartb.Descriptionb.PartSizeb.MinimumQuantity from Inventory a join ItemCreate b on a.PartNo=b.Description where minimumquantity >= quantity Output will be all columns from Inventory table and ItemCreate table with minimumquantity greater than quantity. Thanks