Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Select query not giving desired result — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Select query not giving desired result

Accepted answer
22
Views
2
Comments

Summary:

I'm using below query but it is not giving desired result

Content (required):

The use case is to fetch the Email ID and subscription number of the contact associated with a subscription. Along with this we need to send an email to it. Incase the subscription is not having any contact, then the email address should be a constant email ID (lets say, [email protected]).

Using below query, I'm unable to select a mail id when the query returns null result. In case of a non null result the query works fine. I need the subscription number to come up every time even if email ID is null. Instead of null it should display '[email protected]'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!