Help with a select statement

[mtarby]

I'm having a serious brain cramp today - I'm trying to grab records from the database where the Type_ID matches one of three possible values:

"SELECT * FROM EVENTS, TYPES WHERE EVE_TYPE = TYPE_ID AND TYPE_ID=921 OR TYPE_ID=922 OR TYPE_ID=923 ORDER BY TYPE_ID, EVE_START_TIME"

What am I doing wrong? This gives me junk as a result(which is the best way I can describe the records returned!)

Suggestions?

Thanks in advance

 

[foxbox]

Use ( )

SELECT * FROM EVENTS, TYPES
WHERE EVE_TYPE = TYPE_ID AND
(TYPE_ID=921 OR TYPE_ID=922 OR TYPE_ID=923)
ORDER BY TYPE_ID, EVE_START_TIME


hth,
Foxbox

 

[amorous]

more clearer:

SELECT * FROM EVENTS, TYPES
WHERE (EVE_TYPE = TYPE_ID) AND
(TYPE_ID=921 OR TYPE_ID=922 OR TYPE_ID=923)
ORDER BY TYPE_ID, EVE_START_TIME

VJ

 

[alvika]

SELECT * FROM EVENTS, TYPES
WHERE EVE_TYPE = TYPE_ID AND TYPE_ID IN (921, 922, 923)
ORDER BY TYPE_ID, EVE_START_TIME

Try this.....