tom_ <[EMAIL PROTECTED]> writes: > I am using "disctinct" because of some self-joins and also needed to add an > "order by" clause. An error is shown. Is it not possible to use distinct and > order by together?
I think it is allowed. Executing select distinct * from sys.systables order by tablename; in ij works just fine. Could you show the error message you get, and perhaps what the table looks like? -- dt
