Hello,
After convert the join of ODI to ANSI standard SQL query to ODI Interface. by selecting Order Join Option ODI generate the ANSI Standard SQL.
it highlighting the error like
Critical DataSet Default ODI-15607: Join references the same table twice through other joins.