Need override assistance

Legacy Contributor

Hello,
I have this override in a report,

SELECT CONTACT_PHONE , CONTACT_FAX , FREE_ON_BOARD FROM QUOTE WHERE QUOTE.ID = :QUOTE_ID

and all I want to do is append "NAME" from the "SALES_REP" table where an already existing "SALES_REP_ID" on the report = ID.

Everything I have tried is failing. Can someone please tell me what I am doing wrong or show me what should work?

Error: "Column count not equal to variable count."

Thank you,
Paul

Legacy Contributor

Try using this query

SELECT CONTACT_PHONE , CONTACT_FAX , FREE_ON_BOARD, SALES_REP.NAME
FROM QUOTE
LEFT OUTER JOIN SALES_REP on SALES_REP.ID = QUOTE.SALESREP_ID
WHERE QUOTE.ID = :QUOTE_ID

Be sure to have a destination variable for the new NAME column.