Statement gives error

[snowboardr]

Whats wrong with my sql statement?

SELECT * FROM features WHERE oID=13, 16, 20, 21, 22


Microsoft JET Database Engine error '80040e14'
Syntax error (comma) in query expression 'oID=13, 16, 20, 21, 22'.
/duck/show.asp, line 40

 

[madgenius]

If you want to return the record where oID is one of the values listed then you need to use:

SELECT * FROM features WHERE oID IN (13, 16, 20, 21, 22)

Regards,