Yes, you can. But you should probably reconsider as it will incur abysmal performance
Try to replace the abomination above with UNION like thisCode:SELECT * FROM TBank T JOIN tblDWLoyaltyMember L ON (ISNUMERIC(T.LoyaltyMemberCode) = 1 AND T.LoyaltyMemberCode = L.LoyaltyMemberCode) OR (ISNUMERIC(T.LoyaltyMemberCode) = 0 AND T.LoyaltyMemberCode = L.MembershipID)
cheers,Code:SELECT * FROM TBank T JOIN tblDWLoyaltyMember L ON T.LoyaltyMemberCode = L.LoyaltyMemberCode WHERE ISNUMERIC(T.LoyaltyMemberCode) = 1 UNION ALL SELECT * FROM TBank T JOIN tblDWLoyaltyMember L ON T.LoyaltyMemberCode = L.MembershipID WHERE ISNUMERIC(T.LoyaltyMemberCode) = 0
</wqw>




Reply With Quote