SELECT
 bp_internal_id,
 ta_linkto_bp,
 trans_internal_id,
 ta_linkto_trans,
 trans_linkto_pa,
 trans_linkto_bp,
 ta_amount,
 trans_amount
FROM
 billing_parties
 INNER JOIN transactions ON bp_linkto_pa = trans_linkto_pa
 INNER JOIN transaction_amount ON trans_internal_id = ta_linkto_trans AND 
ta_linkto_bp = bp_internal_id

---

 Comments and Workarounds

---

The problem was with the join optimization, which was throwing off the second condition in the second join that caused a join back to the first table in the SELECT statement. Once the tables were rearranged due to the join optimization, this condition was not evaluated in the correct order, resulting in the improper results. The workaround was to add a NOJOINOPTIMIZE clause to the end of the query.

---

 Resolution

---

Fixed Problem on 6/7/2004 in version 3.30 build 1