November 18, 2009 at 9:36 am
I have a fairly large query and I'm trying to add this simple bit of code to:
(select value
FROM
[ssds_core_msphxx.privatebank.com\core].msphxx.DBO.LN_ACCT LN
INNER JOIN [ssds_core_msphxx.privatebank.com\core].msphxx.DBO.ln_user_def_val LU
ON LN.ACCT_NO = LU.ACCT_NO LU.CLASS_CODE
where user_defined_id in (26)) AS 'CLASSIFICATION'
Works fine when I run it by itself, when I paste it into my query I get an:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Can anyone tell me what I should look for, without having to post this large query? Seems like I get that error no matter where I put the above statement.
November 18, 2009 at 9:40 am
Can't help you with what you have posted. We really need to see ALL the code not just the subquery you are working with.
November 18, 2009 at 9:57 am
I got it, thanks anyhow!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply