When a Select statement with an Inner Join was sent to the Query Builder, it created a new SQL command using incorrect ANSI syntax which returned incorrect results
If the below Select is sent to the Query Builder, it re-engineers the SQL statement incorrectly
select * from transaction_header
left join transaction_item on (etransaction_id=dtransaction_id and item_value=11);
WORKAROUND
None
STATUS
Waiting for a fix in future release of Toad for Oracle.
