>selOptionID = 1 >selMakeID = 12 >STORE 0 TO m.lnModel1, m.lnModel2, m.lnModel3...m.lnModelN >m.lnModel1 = 1 >m.lnModel2 = 7 >m.lnModel3 = 12 >m.lnModel4 = 225 > So, you're suggesting 100+ parameters? >SELECT * > FROM YourTable >WHERE OptionID = ?m.selOptionID AND > MakeId = ?m.selMakeID AND > ModelId IN (?m.lnModel1, ?m.lnModel2, ?m.lnModel3...?m.lnModelN) >>
>SELECT * > FROM YourTable >WHERE OptionID = 1 AND > MakeId = 12 AND > ModelId IN (1, 7, 12, 225,0....,0) >>Which gave you a row for each ModelId, isn't it?