var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SubQuery Problems
Hoping someone can assist me here.
I am reaching an error that states: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
when I run this query
Any advice would be greatfull. Basically what the end user would like to see is any FinancialClass2 that are not equal.
INNER JOIN Fee
ON Fee.ClientID = ChargeActive.ClientID
WHERE FinancialClass2 <>
INNER JOIN Transactions
ON Transactions.CarrierID = Carrier.CarrierID
I thought this would work...now completely lost.
Try replacing your <> with NOT IN
More information on the IN operator can be found here http://w3schools.com/sql/sql_in.asp
Thank you very much George. That worked. Always the simplest solution.
Originally Posted by georgev