This content has been marked as final. Show 1 reply
Cannot tell for sure without seeing the rest of your query (the part after the SELECT in your subquery) but a few things to check -
Are you checking a character field against a numeric value?
ex: where attribute1 = 12345; -- this would give you that error
Are you checking a numeric field against a character?
ex: project_id = '1A2';
Is there a value larger than your max 10,000 ?
it might just be a formatting thing, but there are spaces after your "." in many of the statements in your query, don't know if that would cause this issue but would surely cause "an" issue.
ex: aps . vendor_name -- the space after aps. should not be there.
Try posting your entire query and see if we can be of more hlep.