> >What order do you want ?
> >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
>
> I want to not order, so if "IN (12,11)"..the result is from content_id 12
> then content_id 11 or the resulting order should match the order of IN
> parameters within brackets

As ARNO said, if you do not specify an ORDER BY clause, the
ordering of the resultset is accidental. So you don't have an order
if you do not specify an ORDER BY clause and you DO have an
order if you specify an ORDER BY clause.

What is your problem?


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."