I have selected some results from one table but now I want to order them by a field in a different table. Is this possible? There is no join between the two tables.
SQL is not pychic<BR><BR>it needs solid facts
Maybe you have an implicit join -- show you code and explain what field you need to order by