1

In Table1:

Id  Category-Name  Status
1    Account       Enable
2    Shipping      Disable
3    Payment       Enable

In Table2:

Id  Category-Name  Question  Answer  Status  Position
1   1              Acc       Data     Enable  1
2   3              Del       Quw      Enable  2
3   1              Ship      Wae      Disable  3
4   1              Pay       Que      Disable   4

how to get categoryName in table1 using Category_name in table2?

Improve this question
7
  • You need to do a joint SQL, you have a repository for your tables? Commented Nov 22, 2017 at 20:31
  • expected output:Account->acc,Shipping->ship,Payment->Del Commented Nov 23, 2017 at 16:11
  • your comment is not clear Commented Nov 23, 2017 at 16:13
  • i want to display what are the question under category name Accout? Commented Nov 23, 2017 at 16:26
  • Is it clear?wt can i do Commented Nov 23, 2017 at 16:45

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.