[mikalou]

Not seeing the query statement I'll just take a couple stabs here at possible probs.

If your query statement joins multiple tables and those tables have some identical field names then you'll need to include the table name (ex: table_name.field_name).
or...
You might need to use a "left join" in your query statement.
or...
orderby should be order by.
or...
where clause needs to proceed order by clause.

Can you post your query statement?