Inner or Left Join
I have a parameter called Tab1or3.
If this parameter = 9, I want the below to be a Left Join, otherwise leave it as a Inner join.
Can that be done some way ?
INNER JOIN #CreditStatus1 c
ON Substring(s.custno, 2, 6) = c.custno
If this parameter = 9, I want the below to be a Left Join, otherwise leave it as a Inner join.
Can that be done some way ?
INNER JOIN #CreditStatus1 c
ON Substring(s.custno, 2, 6) = c.custno
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help.
Slubek, your way will work to.
Jim Horn, you read my mind on your suggestion.
Slubek, your way will work to.
Jim Horn, you read my mind on your suggestion.
ASKER
It is a big query.