select * from where Productid in (1,2,3,4,5,6...)


if productid in (1 - 6)

it can do

but i don't know

if productid in (1-3000)

do it can?

... WHERE Productid BETWEEN 1 AND 3000

thanks sir

sorry
i mean
select * from .. where productid in (1,5,12,469,4876,4543438,4343439,5651,1487845,4456 6.........................)
(10000 number)

do it can? or is it error?

why not try it and see for yourself?
what's the worst that can happen if it doesn't work?

in the 5 hours that has elapsed since you first asked the question you coudl have satisfied yourself of the anser to this long long ago, probably 4 hours and 55 minutes ago

Where do these specific product ids come from? If it's another SELECT statement then you have better options than the IN operator .

That Right..!

OK Thank you very much...

I'll try to do it first if it isn't work , I'll post here again