Thread: Re:
-
Re:
No no, what I need is something like this
My query is ..
SELECT
'ACCOUNT NO' = act.ACCOUNT,
'Auto Recharge' = CASE WHEN act.AUTO_RECHARGE = 1
THEN
CASE acr.IS_RECHARGE_CARD WHEN 1 THEN 'PAYMENT DONE'
END
ELSE ''
END,
FROM ACCOUNTS act, CREDITCARD acr
WHERE
act.ACCOUNT = ACR.ACCOUNT
After executing it, I got following Resultset
A00001 'PAYMENT DONE'
A00001 NULL
[CREDITCARD Table has values like
ACCOUNT IS_RECHARGE_CARD
A00001 0
A00001 1
This is occuring when there exists 2 values as 0 & 1 for the field IS_RECHARGE_CARD and I don not want to disturb any clause after WHERE
From above I need to select only record with proper values , not records with NULL or BLANK
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|