Subject | RE: [ib-support] Query IN |
---|---|
Author | Rotandiko Sastroprawiro |
Post date | 2002-08-31T12:15:21Z |
>What order do you want ?I want to not order, so if "IN (12,11)"..the result is from content_id 12
>There's no order specified in your query thus the order is accidental in
>this order.
>Use the ORDER BY clause to order as you want :
>SELECT
> content_id,
> title
>FROM
> content_language
>WHERE
> content_id IN (12,11)
>ORDER BY
> title, content_id
then content_id 11 or the resulting order should match the order of IN
parameters within brackets
[Non-text portions of this message have been removed]