posted 12 years ago
I believe, you need to understand a basic thing about SELECT statements, that is, they return rows of data.
Another thing is that, your table design of Transaction table is inelegant. There is no need for the new_value column as it will be present in the Master table !
After you have made the above change, your SELECT statement should look like the following.
SELECT t1.tranid, t1.ename, t1.eaddr, t2.tranid, t2.fieldname, t2.old_value FROM t1 Master, t2 Transaction WHERE t1.tranid = t2.tranid;
Executing the above query will result in two rows, one containing the eaddr old value and the other containing ename old value (in addition to the other columns).
S.D. MADHAN
Not many get the right opportunity !