0

I have a table named Province with column name id, District and Municipality. So, If I select any District values , then its respective municipality value should be displayed. How do I do it?

enter image description here

If I select District values named Kapilvastu, then its respective Municipality values named Kapilvastu should come as an output.

Slava Rozhnev
10.2k6 gold badges27 silver badges43 bronze badges
asked Apr 24, 2022 at 15:10

1 Answer 1

1

I think an SQL statement like this should work!

SELECT Municipality FROM Province WHERE District = 'District Name'
answered Apr 24, 2022 at 15:14
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.