research notes and output set builder

Hi everyone,

I’m trying to create an output set element called ‘Research tab notes’ with a parameter of note type.  I set up the parameter just fine and was able to construct my output set, but am running into an error with the element.  When I try to execute the output set I get an error stating “the multi-part identifier c.id could not be bound.”  Here’s how I’ve created the element:

Data select:  !.notes

Data from:   (select a.notes, b.customer_no from tx_cust_notes_ext a JOIN tx_cust_notes b ON a.cust_notes_no=b.cust_notes_no JOIN tr_cust_notes_type c ON b.note_type=c.id)

Data where:  c.id in (<<p4>>)

(c.id being my element parameter of note type, pulled from tr_cust_notes_type)

Does anyone have any suggestions? 

Cheers,
Kathleen