Re: SELECT Problem
In article <3cup16$rn5@emory.mathcs.emory.edu>
anand@sin-co.sin-ro.DHL.COM "Chetan anand" writes:
>
> Hi Out there,
>
> Can anyone please give me an explanation about why my following SELECT
> gives me error
>
> 1. Error
>
> SELECT tab002.rowid, trbacc, account_no, seqno
> FROM tab002, mon_13_roll
> WHERE tab002.trbacc = mon_13_roll.account_no
> ORDER BY tab002.rowid>
This is typically only a problem in a report where you cant use the
tablename.columnname syntax in the order by clause.
--
Mike Aubury