SELECT Problem
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
#
# 309: ORDER BY Column (rowid) must be in SELECT list.
#
2. Works Fine
SELECT tab002.rowid recid, trbacc, account_no, seqno
FROM tab002, mon_13_roll
WHERE tab002.trbacc = mon_13_roll.account_no
ORDER BY recid;
SELECT tab002.rowid, trbacc, account_no, seqno
FROM tab002, mon_13_roll
WHERE tab002.trbacc = mon_13_roll.account_no
ORDER BY 1;
Thanks in Advance,
Rgds,
Chetan Anand
DHL International (Singapore) Pte Ltd,
Singapore
e-mail : anand@sin-co.sin-ro.dhl.com