…and why does it tag it to the end of another table that is NOT related to the table I am using.
select d.first_name as christian_name,
d.first_name as firstname,
from (obligations o
inner join debtor d
on (d.entity_no = o.entity_no))
When I reverse engineer this query the designer converts the “firstname” column into a CALCULATED column BUT it places or tags this to the end of the obligations table and not the end of the debtor table as I would expect (logically speaking).
I was hoping TOAD would allow me to drag-drop the same columns into the designer as many times as I would want, like I can in Access and given them separate aliases.
Thanks Debbie, etc