CiviCRM Community Forums (archive)

I am in the process of writing a query against the "civicrm_contribution_recur" and "civicrm_contribution" tables.  My goal is to get the original amount and schedule selected ( such as $100 per month for 12 installments)  plus any completed installments. ( ie if we are 6 months in, I expect to find 6 completed contribution records.)

I am planning to do an SQL JOIN on civicrm_contribution.contribution_recur_id  = civicrm_contribution_recur.id

Will this get the records I intend on?  Is there a better way?

Thanks,