Query to select not Null records in SQL ServerAsk Questions

 Posted on 30 days ago

Dear All,

I have the query mentioned below

SELECT [BNK_OrgNum],[BNK_RecRef],[MsgTp_RecRef],[MsgTyp_MsgID],[MsgTyp_Desc],MsgTyp_FK_ServType,MsgTp_Active
FROM [Bank_Master],[SysDef_MessageType],[Bank_MsgType]
WHERE [MsgTp_FK_MsgType]=[MsgTyp_RecRef] AND [MsgTp_FK_Bank]=[BNK_RecRef]

For Some BNK_OrgNum the MsgTp_Active column=1 ,some MsgTp_Active=0. I need a query where the MsgTp_Active=0 where the BNK_OrgNum  is not using any MsgTyp_MsgID

Share On: facebook gplus twitter
profile
Asked by Chirag Bhatt on 30 days ago Score: 26 points
Add Comment:

Comments

1 Answers

0 Corrected Answers
Aproved Answers
1
Profile
Answered by Joseph Sible on 10/22/2019 9:05:58 AM Score: 36 points

Check below query.

SELECT [BNK_OrgNum],[BNK_RecRef],[MsgTp_RecRef],[MsgTyp_MsgID],[MsgTyp_Desc],MsgTyp_FK_ServType,MsgTp_Active
FROM [Bank_Master],[SysDef_MessageType],[Bank_MsgType]
WHERE [MsgTp_FK_MsgType]=[MsgTyp_RecRef] AND [MsgTp_FK_Bank]=[BNK_RecRef]
AND ([MsgTp_Active]=0 AND BNK_OrgNum IS NULL)

Comments

Add Comment:

Post Your Answers

Existing Members

Sign in to your account
Email Address
Password
New Member?
Sign up and complete profile
Full Name
Email Address
I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the StoodQ newsletters
Guideline to answer a question:

Useful tips to submit your answer
Please read below guidelines before you submit your answer for question.

  • Read and understand question for which you are submitting your answer.
  • Try to avoid grammatical and spell mistake while answering.
  • Do not post any irrelevant information in your answer.
  • Explain your answer with example or any reference link to help who posted question.
  • If you find irrelevant question, please report it to support. Click here to contact support.
  • You agree to the privacy policy and terms of use to submit any contents.

Note: StoodQ is online developers community which helps developer for their difficulty, lets help them with your value contribution.